Explain index covering? List its merits.



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

Post New Answer

More Sybase Interview Questions

Who owns sybase?

1 Answers  


How to swap a db device with another?

1 Answers  


How does sybase replication work?

1 Answers  


What will happen if we create more indexes on a sysbase iq table?

1 Answers  


Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,


What are Magic Tables?

4 Answers   TCS,


What is replication in sybase?

1 Answers  


Sybase 12.5 Database Statistics (Maximum)

1 Answers  


What will cause the size of a stored procedure to grow in sybase?

1 Answers  


When should I execute an sp_recompile in sybase?

1 Answers  


What is the use 'return' keyword in Stored Procedure?

2 Answers  


How do I force an index to be used in sybase?

1 Answers  


Categories