What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79254 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / deepa
A table can have any number of indexes. However, the more indexes there are, the more overhead is incurred as the table is modified. Specifically, when rows are inserted or deleted, all indexes on the table must be updated as well. Also, when a column is updated, all indexes that contain the column must be updated.
| Is This Answer Correct ? | 8 Yes | 11 No |
Post New Answer View All Answers
What is a crud api?
What is right join sql?
What do you mean by dbms? What are its different types?
What is normalization in a database?
what is sql server agent? : Sql dba
What is the difference between view and stored procedure?
What is indexes?
what is innodb? : Sql dba
What is normalization? How many normalization forms are there?
How to start the command-line sql*plus?
how to get @@error and @@rowcount at the same time? : Sql dba
How do we use distinct statement? What is its use?
What is the difference between null value, zero, and blank space?
what is cross join? : Sql dba
What does stand for in sql?
