SQL Query Tuning - Rewrite
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,