why cluster and non clusterindex are used in sqlserver 2000?
explain with example
- 1 Answers
- 4452 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
What are four major operators that can be used to combine conditions on a where clause?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What are the database objects? : SQL Server Architecture
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is a fan-out query in SQL Azure?
How to delete all rows with truncate table statement in ms sql server?
What is the web service used for reporting services?
What is the difference between varchar and varchar types?
What is an index in a database?
What do you understand by recursive stored procedure?
Explain about sql server login?
Why truncate is ddl command?
What is autocommit mode in sql server?
How can delete duplicate records in cte in sql server?
What kind of problems occurs if we do not implement proper locking strategy?
