Clustered Index

Can someone explain me what is the difference between a clusestere and a
non-clustered index?1. you can only have one clustered index on a table
2.tables with clustered index are physically sorted
based on the clustered index
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Hugo Madureira" wrote:

> Can someone explain me what is the difference between a clusestere and a
> non-clustered index?
>|||Hugo Madureira wrote:
> Can someone explain me what is the difference between a clusestere
> and a non-clustered index?
http://msdn.microsoft.com/library/d...r />
_8sit.asp
robert|||For tables that have a clustered index:
The data rows on each data page are stored in order, based on the clustered
index key. Each data page stores a reference to the previous and next pages
to create an ordered sequence of pages called a doubly-linked list. The
links not only keep the pages in sequence but they make it easy and fast to
insert a new page anywhere in the sequence by updating the links on the
pages between which the new page is inserted.
For heaps, which are tables that have no clustered index:
The data rows are not stored in any particular order, and the data pages are
not sequenced in a linked list. New pages are simply added to the heap.
Planning and Creating Indexes
http://www.microsoft.com/technet/pr...s/c0618260.mspx
"Hugo Madureira" <hugomadureira@.hotmail.com> wrote in message
news:u%23F9MyK2FHA.3524@.tk2msftngp13.phx.gbl...
> Can someone explain me what is the difference between a clusestere and a
> non-clustered index?|||Hugo,
I'd recommend that you take the time to read the following resources:
1. Indexes, Clustered Indexes and Nonclustered indexes in the SQL Server
Books Online.
2. SQL Server 2000 Operations Guide - System Administration (focus on
indexing sections)
http://www.microsoft.com/technet/pr...in/sqlops4.mspx
3. Tips on Optimizing SQL Server Indexes
http://www.sql-server-performance.c...ing_indexes.asp
4. Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
HTH
Jerry
"Hugo Madureira" <hugomadureira@.hotmail.com> wrote in message
news:u%23F9MyK2FHA.3524@.tk2msftngp13.phx.gbl...
> Can someone explain me what is the difference between a clusestere and a
> non-clustered index?