What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 81323 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 are local and global variables and their differences? : Sql dba
What is inner join in sql?
How do you copy a table in sql?
What is autocommit sql?
How global cursor can be declare with dynamic trigger ?
How many types of normalization are there?
What is faster join or subquery?
how to drop an existing view in mysql? : Sql dba
How do I turn a list into a table?
Is record in oracle pl sql?
How do you use collections in procedure to return the resultset?
What is a null value?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the difference between having clause and where clause?
Why do we use partitions in sql?
