Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10149 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
What types of replication are supported in sql server?
What are the Advantages of using CTE in sql server?
What is the purpose of linked server configuration in sql server?
Do you know what is replace and stuff function in sql server?
Explain about Normalization?
Define outer join in sql server joins?
Can you name a few encryption mechanisms in sql server?
How to enter date and time literals in ms sql server?
Give main differences between "Truncate" and "Delete".
What are the types of processing and explain each? : sql server analysis services, ssas
What are data driven subscriptions?
please differentiate between delete and truncate?
What is function of ROLLUP ?
What is the beast way to write CTE in SQL Server ?
How is sql used in sql server?
