Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10123 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 function does a database engine serve in the sql server?
How do you check sql server is up and running?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Why truncate is ddl?
Define inner join? Explain with an example?
What is sub query and its properties?
Explain about unique identifier data type in sql server?
Explain a join?
What do you mean by normalisation?
What is difference between getdate and sysdatetime in sql server 2008?
What is oltp (online transaction processing)?
What is difference between delete and truncate commands?
How do you send email on SQL Server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What do you understand by mirroring?
