Explain index covering?



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

Post New Answer

More Sybase Interview Questions

How to change varchar(m) to varchar(n) in sybase?

1 Answers  


How can I tell the datetime my server started?

1 Answers  


Which version of open client works with which ase in sybase?

1 Answers  


What are the vital features of sybase?

1 Answers  


What are the important features of sybase?

1 Answers  


How do check the current running processes?

1 Answers  


How do I find the oldest open transaction in sybase?

1 Answers  


Can you create your own sps for system wise?

1 Answers  


Explain coalesce.

1 Answers  


What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

1 Answers  


What does –i option do in sybase tools?

1 Answers  


What is the command for quitting from sybase?

1 Answers  


Categories