Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2003 @ 22:19:47 GMT
| Subj: | | Re: How to query a table having both Primary as well as Secondary Index |
| |
| From: | | Terry Stover |
Before you define an SI try just collecting stats on the 3rd column. A secondary index will cost you 8+ bytes per row and slow down
maintenance (particularly multiload). Join indexes won't work with multiload. I've heard less than favorable comments on the utility of
USI's from people who should know (former TD consultants), but haven't experimented with them myself.
A 1TB table sure sounds like a good candidate for partitioning and compression.
| 
