Explain index covering? List its merits.
Answer / Vandana Kumari
Index covering occurs when an index contains all the columns needed to fulfill a database query, thus avoiding the need to access the underlying table. This can improve performance by reducing the amount of data that needs to be read from disk.nMerits:n- Faster query executionn- Reduced I/O operationsn- Improved concurrency
| Is This Answer Correct ? | 0 Yes | 0 No |
Who owns sybase?
How to swap a db device with another?
How does sybase replication work?
What will happen if we create more indexes on a sysbase iq table?
Is data insertion is fast in SYBASE IQ if we have more indexes on a table?
What are Magic Tables?
What is replication in sybase?
Sybase 12.5 Database Statistics (Maximum)
What will cause the size of a stored procedure to grow in sybase?
When should I execute an sp_recompile in sybase?
What is the use 'return' keyword in Stored Procedure?
How do I force an index to be used in sybase?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)