View previous topic :: View next topic
|
Author |
Message |
latron
New User
Joined: 10 Dec 2008 Posts: 2 Location: CHENNAI
|
|
|
|
Having understood, that Native Key Dictates the Physical Sequence in which data is stored in Data Area. Would it perform better if the Index is created based on Native Key And my 'where' clause also only the columns defined in Native Key ?
Thank you... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Suggest you spend some time in the DBA Admin Guide. I believe your understanding will benefit.
In many tables (even most tables), the master key and the native key are the same key. There are very often multiple other keys to the data in the table - either simple or complex keys.
Proper definition of the keys depends on how the data will be used.
Quote: |
Would it perform better if the Index is created based on Native Key And my 'where' clause also only the columns defined in Native Key ?
|
Performance is best when the WHERE predicate(s) is/are completely satisfied by the column(s) of some particular key. |
|
Back to top |
|
|
latron
New User
Joined: 10 Dec 2008 Posts: 2 Location: CHENNAI
|
|
|
|
That's clear. Thank you. |
|
Back to top |
|
|
|