What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79243 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sandip kumar chaturvedi
index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.
| Is This Answer Correct ? | 20 Yes | 33 No |
Post New Answer View All Answers
What is the difference between cross join and natural join?
Where can I learn sql for free?
What is crud sql?
How do I remove duplicates in two columns?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are inner outer left and right joins in sql?
Why do we go for stored procedures?
What is a subquery in sql?
Are subqueries faster than joins?
Is nosql faster than sql?
Can we rollback truncate?
What are the different sql languages?
What are the different types of a subquery?
Can we perform dml in function?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
