2.5 billion row table scan...

Due to time constraints, we may have to stick with scanning 2.5 billion row table (and figure out another access path later). It's partitioned (each partition about 50-60 mil rows). Current memory is at 4 Gig, and there are six processors (Sun machine). We will probably double the memory soon and add two more processors.

With it's current configuration, however, it was still cheaper to scan the table than use any indexes, and it takes roughly 18 hours.

Can you suggest anything to speed up the scan?

Thank you!

Sergey

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 05 2000 - 00:00:00 CDT