Archives of the TeradataForum
Message Posted: Wed, 19 Jan 2005 @ 09:13:02 GMT
| Subj: || || Re: Are my Primary Indexes being used? |
| From: || || Victor Sokovin |
| ||Yes. I understand the PI function and how they work. I can see the fields that are being used with object logging but do not know if the
Indexes are being used|| |
In many databases the analog of PI could be a structure separate from the table, and that's probably the background of the question. In
TD, the PI is just a part of the table (the word "index" might be confusing if you come from the different). There is simply no other way for
users to get to the data except via the PI. So, as far as I can see, there is no difference, in this context, between the "PI fields" and the
"Indexes". If you believe that the former are "used" then the latter will be used as well.
Hope this helps.