Fast fetches on large table

From: <rosmit_at_my-dejanews.com>
Date: Tue, 06 Apr 1999 21:50:00 GMT
Message-ID: <7edvi5$lep$1@nnrp1.dejanews.com>

Hello. I'm looking for advice on setting up a table to allow for the fastest retrieval of data.

Application: I have a multi-threaded Pro*C app that is fetching from Oracle. The one table it fetches from holds name and address info. The query fetches back all records for a zip code. The average zip bucket has around 10,000 records.

There are about 47,000 unique zips in the US.

Ideas: * partitions - partition on zip with each partition in its own tablespace containing several datafiles on different disks. This sounds difficult to setup and may be too many partitions for Oracle to handle(?).

hash
cluster

What are your thoughts?

thanks.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 06 1999 - 16:50:00 CDT