SQL Performance (MOSC)

MOSC Banner

SQL Query Tuning - Rewrite

edited Mar 12, 2014 3:29PM in SQL Performance (MOSC) 3 commentsAnswered ✓

Hi All,

Is there a better way to write this SQL Query ?

SELECT i.ITEM_ID,

       i.ITEM_TYPE,

       i.START_DATETIME,

       i.END_DATETIME,

       ip0.PROPERTY_STRING AS COMPLETION_NAME,

       ip1.PROPERTY_STRING AS COMPLETION_ACTIVE,

       ip2.PROPERTY_STRING AS COMPLETION_COMMENT_1,

       ip3.PROPERTY_STRING AS COMPLETION_SHORT_NAME,

       ip4.PROPERTY_VALUE AS COMPLETION_LATITUDE,

       ip5.PROPERTY_STRING AS COMPLETION_ACC_ID,

       ip6.PROPERTY_VALUE AS COMPLETION_LONGITUDE,

       ip7.PROPERTY_STRING AS COMPLETION_FDC_ID,

       ip8.PROPERTY_STRING AS COMPLETION_DATA_STATUS,

       ip9.PROPERTY_STRING AS COMPLETION_LEGACY_ID,

       ip10.PROPERTY_STRING AS COMPLETION_DATUM,

       ip11.PROPERTY_STRING AS COMPLETION_ACQUISITION_ID,

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