Re: P a r t i a l k e y s

From: PCS Technologies, Inc. <dadkins_at_pcstech.com>
Date: 1997/04/29
Message-ID: <3366CDB6.61@pcstech.com>#1/1

miguel wrote:
>
> Does anyone plese tell me if we can use partial keys on Oracle 7.1.6? For
> example if we can use the first two caracters from a VARCHAR column (NOT
> NULL) ?
I ran two queries with sql_trace turned on. First, select count(*) where container_id like '0009103%'. The second, select count(*) where container_id like '%9103%'

The first query used the appropriate index, using a range scan of that index. The second did a table scan. Received on Tue Apr 29 1997 - 00:00:00 CDT