In basic terms the clustered index key determines the physical order in which the data pages are stored. That means that all topics starting with �A� will come first in the book then �B� and so on in alphabetical order. As a result of this you can have only one clustered index per table.
The data pages of the non-clustered index are not stored in the order of the index key. This is like a book with an index at the back where you locate a topic in alphabetical order in the index and then skip to the pages to find the topic. You can have more than one non-clustered index per table and a table that has a clustered index can have several non-clustered indexes.
Varden Morris
J. Wray & Nephew Ltd. - Group I.S.
Phone: (876) - 923 - 6141 Ext. 2226
Fax: (876) - 923 - 5372
Cell: (876) - 3833566
Email: [EMAIL PROTECTED]
Padmaja Iyingar <[EMAIL PROTECTED]> wrote:
Hi,I am trying to understand the difference between a normal index and a cluster index?.Any example would be very greateful.Appreciate your help.Thanks,Padmaja
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
