What are the type of Indexes? which one is best, why?
Answer Posted / arun pandey
Hi
1)Clustered Index
2)NON-Clustered INdex
But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered
Arun Pandey
A1Technology
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is index in an assignment?
What triggers long term care?
Explain for xml explicit mode?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Is the order of columns in the set clause important in ms sql server?
What do you understand by sql server agent?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is an entity-relationship diagram (erd)?
What are the triggers in sql?
whats the maximum size of view state??
Do you think BCNF is better than 2NF & 3NF? Why?
how to determine the service pack currently installed on sql server? : Sql server database administration
How does the report manager work in SSRS?
Does partitioning help performance?
What program is used to store the data source file?