Oracle 10g Optimization

[pks6a]

Hi I am running an SQL query, which joins 6 tables with other restricts applied. However when I add a new restrict the query slows down incrementally, in fact it actually becomes non feasible. The where clause restrict I am adding is based on an index.

Can anybody help

Thanks

Pks6a

[Dave44]

I would love to help you with this. In order to do so i would need to see the query's (both before and after the additional restriction) as well as their respective explain plans. This is so i can understand what oracle is doing and what you are trying to acheive.

I can start with that

[seraphstream]

Hi I am running an SQL query, which joins 6 tables with other restricts applied. However when I add a new restrict the query slows down incrementally, in fact it actually becomes non feasible. The where clause restrict I am adding is based on an index.

Can anybody help

Thanks

Pks6a

Sounds like a hard parse problem.

please pacth ORACLE 10g.

for imformation see

Oracle 10g is slow