Re: Query taking too long - Please Help

Hi,

1. I’d suggest first making sure you have enough RAM in your server
   (it's always the simplist answer).
   
2. I generally have two primary keys on a table, a default key ‘actual’ primary key (from an oracle perspective), which is always a single field
   (number (x,0), where x is the largest count you expect). The second
   primary key is the 'real' primary key, a unique index that enforces uniqueness from the application perspective. Single field joins are always faster.

Are you OFA compliant? If you only have 1 or 2 drives, then the disk I/O is gong to be a bottleneck.

More RAM usually solves a lot of problems. Proper Indexing is also important.

Hope this helps. Received on Fri Feb 05 1999 - 09:47:37 CST