Database Administration (MOSC)

MOSC Banner

Why is this query not using indexes?

edited Jan 19, 2010 4:44PM in Database Administration (MOSC) 5 commentsAnswered ✓
SQL> SELECT * FROM (SELECT dsl_modems.pk_dsl_modem_id, dsl_modems.serial_number, mtm_dsl_modem_2_cus tomer
  2  .fk_dslam_port_id, mtm_dsl_modem_2_customer.fk_customer_id
  3  FROM dsl_modems, mtm_dsl_modem_2_customer  
  4  WHERE      mtm_dsl_modem_2_customer.fk_dsl_modem_id (+)= dsl_modems.pk_dsl_modem_id
  5  AND      dsl_modems.fk_modem_status_id = 'WORKIN'
  6  AND fk_dslam_port_id IS NULL 
  7  AND dsl_modems.brand='ST716g'
  8  AND (fk_customer_id IS NULL
  9  OR   (fk_customer_id IS NOT NULL
 10  AND   pk_dsl_modem_id
 11  NOT IN (SELECT fk_dsl_modem_id  FROM mtm_dsl_modem_2_customer                                 

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