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 ?
Joined: 23 Nov 2006 Posts: 19270 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.