What are the type of Indexes? which one is best, why?
- 6 Answers
- 8549 Views
- I also Faced
- E-Mail Answers
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
Explain the flow of creating a cube? : sql server analysis services, ssas
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is isolation levels?
How to list all tables in the database using odbc_tables()?
What are the basic features of a trigger in ms sql server?
What is de-normalization and what are some of the examples of it?
What is store procedure? How do they work?
How to find the source of a table in sql server?
What are the types of table?
Explain syntax for viewing trigger?
Why use stored procedures in sql server?
Will sql server 2005 allow you to reduce the size of a column?
What is built-in function?
Is mysql the same as sql server?
