SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Performance tuning with Huge Lookup table

user604558Feb 2 2009 — edited Feb 13 2009

Hi,

I have a sql query,

select * from A,B where A.col1=B.col1

If A is driving table and B is lookup table, the volume of lookup table B is very huge, do we have any specific hints or performance tuning techniques for this scenario?.

I remember with some of the etl tools (eg:IBM datastage) there are specific lookup stages for (huge lookup data-set and small lookup data-set).

Can you please advise?.

Thanks in Advance.

This post has been answered by SomeoneElse on Feb 13 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2009

Added on Feb 2 2009

8 comments

766 views