Re: Parallel Query Instant Gratification?

select count(*) from large_table;

tends to prove the point

select count(*) from large_table where unindexed_date_column = to_date('..... guaranteed not present value');

is also interesting.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Doug Cowles wrote in message <377240E2.613F32A9_at_bigfoot.com>...
>I'm going to be installing parallel query and striping several very
>large
>tables with it. I'll be reading up on it more on the weekend so forgive
>
>me if this sounds lazy.. but what's a real quick way I can see an
>immense
>performance gain without clogging up the experiment with 1 million rows
>of output going somewhere. Maybe a cursor? Is there a way to force
>a full table scan without actually returning anything to see
>improvements in
>time? Maybe something like select * from largetable where pk = 0+1-1?
>I'm looking to prove an improvement very quickly and easily. I thought
>doing a full table scan without returning anything before and after the
>table
>has been striped and made parallel would help me sleep better. Any
>thoughts
>for quick experiments?
>
>- Dc.
>
>
Received on Thu Jun 24 1999 - 16:12:46 CDT