Monday, December 3, 2007

What are the types of indexing available in MSSQL 2000

What are the types of indexing available in MSSQL 2000

Cluster index is an index that stored by MSSQL in a B-tree format whereby the parent tree contains references to the child below it and it is particularly useful in storing value with a range of values.

Full text indexes are used to search complex stream of strings effectively and efficiently that cannot be created for multiple database, that means multiple database cannot share a full text indexes.

No comments: