Can any 1 please tell me whats a clustered index

I am new to sql programming and would like to know what a clustered index is. Can you also tell me where i can get a copy of SQL ANSI standard from. Is it free?
Thanks
bye

Refer Books Online installed with SQL Server Installation for more details.

Gaurav

...And then you may also want to read this good articles on the same subject.


1. http://www.sql-server-performance.com/clustered_indexes.asp]
2. http://www.devx.com/getHelpOn/Article/10016/0/page/2]
3. http://www.sqlmag.com/Articles/Index.cfm?ArticleID=24483]
4. http://www.sqlmag.com/Articles/Index.cfm?ArticleID=24700]



NHO

To find a copy of the ANSI SQL standard you can start by looking at the ANSI website,http://www.ansi.org. They have redesigned their site since the last time I looked at it, and I do not know for sure where you can get the standard. You used to be able to go to an order form and order it, however there was a charge for a copy.

There are actually many versions of the standard, SQL-86, SQL-92 (basic, intermediate, and advanced versions), SQL-99 (there are multiple versions of this one also, although this is mostly extensions to SQL-92), and SQL-200n is in the works. Most major DB vendors only applied for compliance testing to the basic version of SQL-92, however they all support a good deal of features from the intermediate and advanced versions, as well as most of the features from SQL-99.

I would suggest you search the web for any information you need, most anything you need to know is out there.

Thanks a million guys