What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79184 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 the different type of joins in sql?
Why schema is used in sql?
Where the sql database files are stored?
How do you copy a table in sql?
what is timestamp in mysql? : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is left join in postgresql?
What are the operators in sql?
What is the maximum number of triggers, you can apply on a single table?
how to analyze tables with 'mysqlcheck'? : Sql dba
How can you load microsoft excel data into oracle? : aql loader
Can we create clustered index without primary key?
Can we call a function containing dml statements in a select query?
What is the difference between nested table and varray?
What are some predefined exceptions in pl/sql?
