Re: cover index

From: <quanunique_at_my-deja.com>
Date: 2000/01/26
Message-ID: <86neqr$mk1$1_at_nnrp1.deja.com>#1/1


In article <388f2616_at_bronze.hkabc.net>,   "Frankie Kong" <frankiek_at_hkabc.net> wrote:
> what is cover index
>
>

If the key of an index contain all the attributes mentioned in a query, then the index is a cover index for this query. For instance, a index on <age, name> is a cover index for query " return the names of the people older than 20"

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 00:00:00 CET

Original text of this message