Database Tuning (MOSC)

MOSC Banner

generic delete query

edited Dec 29, 2011 12:08AM in Database Tuning (MOSC) 8 commentsAnswered
Oracle EE 11.2.0.2 on rhel 5.7

Can someone tell me if the following query can be improved? It takes several minutes to run.

Thanks.

delete from cle.SAKAI_REALM_RL_FN SRRF

      where SRRF.REALM_KEY in

                (select R.REALM_KEY from cle.SAKAI_SITE S, cle.SAKAI_SITE_PROPERTY SP, cle.SAKAI_REALM R

                     where SP.NAME='term_eid'

                        and CAST (SP.VALUE as VARCHAR(10)) ='2012F'

                        and SP.SITE_ID=S.SITE_ID

                        and S.TYPE='course'

                        and R.REALM_ID like '/site/'||S.SITE_ID)

        and SRRF.ROLE_KEY in

                (select ROLE_KEY from cle.SAKAI_REALM_ROLE SRR where

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