Interested to Buy Any Domain ? << Click Here >> for more details...
why cluster and non clusterindex are used in sqlserver 2000?
explain with example
- 1 Answers
- 4751 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Difference between primary key and clustered index?
How to drop existing views from a database in ms sql server?
Explain the categories of stored procedure?
What is the standby server?
How to access the inserted record of an event?
What is field with example?
What stored procedure can you use to display the current processes?
How can you append an identity column to a temporary table?
Is mysql the same as sql server?
How to enter date and time literals in ms sql server?
Can a table be moved to different filegroup?
How to update values in a table with update statements in ms sql server?
How does recursive cte works in sql server?
What is difference between joins and subqueries?
Is there any difference between the primary key and unique key?
