![]() |
|
Archives of the TeradataForumMessage Posted: Fri, 01 Nov 2003 @ 01:27:29 GMT
I agree, best not to drop the SI because the volume of inserts is small in relation to the size of the table. I'd like to add that what is considered small should go up in V2R5 because performance of secondary index maintenance has been much improved. In a test report that I read, the performance was as much as 600% better. Jon
| ||||||||||||||||||||||||||||||||||||||||||||||||
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
| Last Modified: 30 Jun 2008 | ||||||||||||||||||||||||||||||||||||||||||||||||