Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clustered & NonClustered Indexes

Status
Not open for further replies.
TorrediPisa

TorrediPisa

Programmer
Apr 15, 2004
67
IT
Hello to everyone,

I would need a simple explanation about a simple concept that unfortunately seems so far away from my understanding:

What do "Clustered Index" & "NONClustered Index" mean?
What is the difference between them?
Could You please tell me with a simple example?

I am very obliged for Yr help.
Best Regards

Fabio
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JOEYB99
  • Locked
  • Question
Slow Database, Need Indexes? 1
Replies
9
Views
108
dhookom
dhookom
BNPMike
  • Locked
  • Question
How does Access use Indexes? 1
Replies
2
Views
83
jsteph
jsteph
hpaille
  • Locked
  • Question
Create indexes in macro
Replies
1
Views
66
Ed2020
Ed2020
kkitt
  • Locked
  • Question
Indexes on a Linked Text file
Replies
2
Views
45
DrSimon
DrSimon
kiiwii2
  • Locked
  • Question
<Index name> isn't an index in this table. Look in the Indexes collect
Replies
1
Views
78
M8KWR
M8KWR

Part and Inventory Search

Sponsor

Back
Top