Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Indexes		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

daiondoroga
Starting Member

10 Posts
Posted - 14 August 2006 :  10:12:41  Show Profile
Greetings my SQL friends.

Could somebody give me a brief and sweet explanation of the difference between a clustered and a non clustered index and when they should be used.

I have read several articles but I am after the opinions of the developers who are members on this forum.

I hope this becomes a good discussion about this topic.

Thanks in advance.
http://www.cybersoftdesigns.com

Affordable web design, web application development, content management systems and ecommerce solutions for small business

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 14 August 2006 :  10:37:06  Show Profile  Visit HuwR's Homepage
in general non-clustered indexes are used to retrieve single records from a table whereas clustered indexes are used to retrieve multiple rows from a table.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07