SQL Performance (MOSC)

MOSC Banner

sql query taking long time

edited Oct 22, 2015 10:03AM in SQL Performance (MOSC) 3 commentsAnswered

We are using database version 11.2.0.2

We have the following query that is taking a long time. We do have a primary key index on productdata table on column prd_info_id and a composite index with prd_info_id column included on testdata table. The only thing is we don't have an index on upd_date column on testdata table. I am going to try to create an index on the upd_date column and see if the query will speed up. Gurus, any suggestion here? Please advise. Thank you.

 

select productdata.serial_no, testdata.tst_ivalue,

 

testdata.tst_judge, testdata.tst_rvalue,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center