Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

What types of indexes are available in SQL Server 2000?

7 like 0 dislike
Hello
What is an index? What types of indexes are available in SQL Server 2000?
please reply me. i am waiting for your reply.
Thanx
asked 1 year ago by eagles11 (179,830 points)

1 Answer

1 like 0 dislike
 
Best answer
Any experienced database developer should be able to answer this question with ease. Some of the less-experienced developers will be able to answer it, but with a little less clarity.
In its most simple terms, an index is a data structure used to provide quick access to data in a database table or view. In SQL Server, they come in two flavors: clustered and non-clustered. Clustered indexes store the data at the leaf level of the index. This means that whichever field(s) in your table are included in the clustered index, they will be stored in an orderly fashion in the table. Because of this sorting, you can only have one clustered index per table. Non-clustered indexes contain a row identifier at the leaf level of the index. This row identifier is a pointer to a location of the data on the disk. This allows you to have more than one non-clustered index per table.
answered 1 year ago by DBA-boss (120,990 points) edited 1 year ago by DBA-boss

Related questions

7 like 0 dislike
1 answer
7 like 0 dislike
1 answer
7 like 0 dislike
0 answers
5 like 0 dislike
1 answer
5 like 0 dislike
1 answer
asked 1 year ago by daneim (127,080 points)