Home

Query Improvement

Hi All, I'm hoping someone can help me. I have the query below with the explain plan. It takes more than 10 minutes to complete. There are only 128 records in the table named INDUSTRY and about 150,000 records in the table named BROKER_REP_LOOKUP, and BROKER_REP_LOOKUP is actually a snapshot. There are also the following indexes on the tables:

full article | source