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: Index creation

Re: Index creation

From: David Cressey <david_at_dcressey.com>
Date: Fri, 09 Aug 2002 19:40:18 GMT
Message-ID: <CUU49.47$lq1.6287@petpeeve.ziplink.net>


A lookup is faster than a range scan. The extra speed may be enough reason for creating the B index.

--
Regards,
    David Cressey
    www.dcressey.com
Received on Fri Aug 09 2002 - 14:40:18 CDT

Original text of this message

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