Explain Non-Clustered index on a clustered table

Article View: bit.listserv.sqlinfo

Article #307

Back to bit.listserv.sqlinfo Previous Next

#307

From: pooh
Date: Tue, 04 Dec 2001 03:43

5 lines
1227 bytes

I am just wondering if someone could explain to me how SQL Server fetches
records using a Non-Clustered Index in a Clustered table.  Any help is
greatly appreciated.

joe joe

Technical Details

Message-ID: <YDXO7.20039$nm3.866730@news1.rdc1.bc.home.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!nntp.cs.ubc.ca!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!news1.rdc1.bc.home.com.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,fb2f8388db4041c4,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2001-12-03 19:43:52 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!nntp.cs.ubc.ca!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!news1.rdc1.bc.home.com.POSTED!not-for-mail
From: "pooh" <jitalian@hotmail.com>
Newsgroups: bit.listserv.sqlinfo
Subject: Explain Non-Clustered index on a clustered table
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <YDXO7.20039$nm3.866730@news1.rdc1.bc.home.com>
Date: Tue, 04 Dec 2001 03:43:52 GMT
NNTP-Posting-Host: 24.70.225.144
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.bc.home.com 1007437432 24.70.225.144 (Mon, 03 Dec 2001 19:43:52 PST)
NNTP-Posting-Date: Mon, 03 Dec 2001 19:43:52 PST
Organization: Excite@Home - The Leader in Broadband http://home.com/faster