Clustered and Non-clustered indexes

hi,

how clustered indexes and non-clustered indexes been saved in memory?

non-clustered is a table of a references to the actual table?

and what about clustered indexes?

thanks.

Indexes have nothing to do with memory.

A simple way to explain indexes is just as an index in a book. You have the non-clustered index telling you on what page you can find specific information. The clustered index defines the order in which they are stored, eg. name in a phonebook could be seen as a 'clustered' index because the phone numbers are listed in alphabetic order by name.

I tried to give a very simple explanation but there are a lot of resources explaining indexes on the internet. Choosing the rights indexes is an art so try to learn as much as possible about it.

Hth