| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Queries and Speed
Ben Clegg wrote:
>
> I have a simple application that we are porting from a Paradox database to
> Oracle. A simple join query that takes about 3 seconds in Parodox takes
> about 12 seconds in Oracle. Is it normal for Paradox to outperform Oracle
> or am I missing something? What are the most common steps that you can take
> to speed up a query?
Run EXPLAIN plan...if you aren't sure what this is, then its time to check out the server tuning manual...
Some thigs to start with:
make sure the tables analyzed if you're using the cost option which is likely (its the default)
are there appropriate indexes on the tables
are the tables sized correctly - 1 extent is good, up to 20 is even fine (assuming that you have got them as reasonable multiples of db_multiblock_read_count * block size ) , 1000's of extents is bad
are the tables on hot spots on disk
blah blah blah blah
Hope this helps..
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Sep 10 1999 - 05:05:24 CDT
 |
 |