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?
Received on Thu Jun 24 1999 - 09:29:54 CDT
