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.
Clustered and Non-clustered indexes
Hot Topic
- remote queries (linked servers) wait or timeout during a DBReindex of any table/index
- Value dimension
- SQL Server DTS - viewing transformations
- Class does not support aggregation
- Msg 468, Level 16, State 9, Line 1 --Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_Ge
- SQL Transact: Subquery
- Problem Understanding ADO.Net:SQL Connection Manager
- Moving ntext to nvarchar(max)
- Controlling number of Matrix rows displayed
- Custom Component - Change Data Type
SQL Server
- Announcing SQL Server Everywhere Edition
- Unable to achieve database connectivity with my ASP.NET web application
- Complex query involving multiple tables
- SQL Server Diagrams?
- Upgrade SQl 2005 Beta {9.00.0852} to {9.00.1399.06}
- problems with report
- SSRS 2005 Connecting to data on 2000
- Merge Replication IIS Worker Process Error
- Keep registered servers in tact
- selecting colunm with a space ''
Clustered and Non-clustered indexes
adange
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