What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / swapna vamsi
Indexs are used for the faster retrivel of data.
two types of indexes
Cluster index,unclustered index
we can have one cluster index and uotp 249 cluster indexes
for a table
| Is This Answer Correct ? | 63 Yes | 38 No |
Post New Answer View All Answers
What does desc stand for?
How do I write a sql query in pgadmin 4?
what is self join and what is the requirement of self join? : Sql dba
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How to revise and re-run the last sql command?
What is the difference between cross join and natural join?
State some properties of relational databases?
What is asqueryable?
What is the use of desc in sql?
Does sql view stored data?
What company owns postgresql?
What are different functions in sql?
Why are indexes and views important to an organization?
what is a trigger in mysql? Define different types of trigger. : Sql dba