Explain index covering?
Answer / Satendra Kumar Bharti
Index covering is a technique in Sybase that allows a query to use an index to retrieve all the necessary data without having to access the actual table data. If an index contains all the columns needed for a query, then the database engine can read the data directly from the index, thus improving query performance by reducing the number of disk reads required.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to change varchar(m) to varchar(n) in sybase?
How can I tell the datetime my server started?
Which version of open client works with which ase in sybase?
What are the vital features of sybase?
What are the important features of sybase?
How do check the current running processes?
How do I find the oldest open transaction in sybase?
Can you create your own sps for system wise?
Explain coalesce.
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
What does –i option do in sybase tools?
What is the command for quitting from 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)