Re: Slow selections

From: DaPenzo <tony_at_zest.nl>
Date: Thu, 10 Feb 2000 15:24:46 +0100
Message-ID: <87uhs8$vl$1@news1.xs4all.nl>

Martin Hepworth wrote in message <38A2B20E.66A26E36_at_totalise.co.uk>...
>HI
>Oracle won't split the where up and use an index on the partitial where
>clause. If you want this speeded up you'll need an index with zip and
>lname in it.
>

I can't believe it doesn't!
Using one the index is always faster than a tablescan... I've noticed when I use a FIRST_ROWS hint it speeds up dramatically. I can't figure out why this isn't the default value... Received on Thu Feb 10 2000 - 08:24:46 CST