Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: cover index

Re: cover index

From: <quanunique_at_my-deja.com>
Date: 2000/01/26
Message-ID: <86neqr$mk1$1@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US