Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10090 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / monal
Indexes are mainly used for faster retrival of the data
from the table or view.
Primary key is best candidate for creation of clustered
key: reason all the values in Primary Key column would be
unique. Also you can create clustered index on foreign key
column of table which is used quite frequently in the join
condition and on the column which is used frequently in the
where clause of the table.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
When would you use it?
What are the differences between union, intersect, and minus operators?
How efficient you are in oracle and SQL server?
How to read data in a table with "select" statements?
Explain microsoft sql server functions?
What is the cpu pressure?
How to write character string constants or literals in ms sql server?
Explain data warehousing in sql server?
what are the disadvantages of cursors? : Sql server database administration
What is inner join in sql server joins?
What are the characteristics of modern DBMS?
Does windows server 2016 come with sql server?
Can you import Microsoft Excel data to SSRS?
Is there any difference between primary key and unique with the not null condition?
What is Federation Root Database?
