http://goo.gl/EmKxy0

Archive

Posts Tagged ‘Index coverage’

Index coverage

July 22nd, 2012 No comments

Query — What is  “Index Coverage of the query”?

Answer — It is defined as whether the query can be satisfied by retrieving data from the index pages without accessing the data pages . ASE can use indexex that covers query, even if no where clause are included in the query.

 

Query —  Can a query use index even if no where clause are included in the query?

Answer — Yes, as described above ASE can use indexes that covers query, even if no where clause are included in the query.