 |
 |
Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2003 @ 12:22:52 GMT
| Subj: | | Re: How to query a table having both Primary as well as Secondary Index |
| |
| From: | | Fenwick, Ruth |
Glenn's right, if more of your access is via the 3 columns than the 2, it makes a better PI especially if it changes the PI from a NUPI
to a UPI.
The optimizer really favours the PI over a SI, so it may not use the secondary index. It might if the secondary is a USI.
Since it's a single AMP operation, why are you concerned about the 2 column PI? Is it very non unique?
Ruth Fenwick
Database Services
| |
