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
- 4833 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
How to get the number of affected rows?
Will sql server 2005 allow you to reduce the size of a column?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What do you mean by 'normalization'?
Why does sql studio use a single registered database repository? : sql server management studio
What do you mean by SQL injection attack?
What is sql server management studio? : sql server management studio
How many joins in sql server?
What are triggers? How do you invoke a trigger on demand?
What is the federation in sql azure?
What are the difference between “where” and “having” clause in sql server?
What are different types of raid configurations? : SQL Server Architecture
How to use transact-sql statements to access the database engine?
What is the difference between ddl and dml?
What are the types of joins in sql?
