Better Way to Rewrite this SQL Query ??

Hi All,

Is there a better way to rewrite the SQL Query ? The Query takes a long time to access 2,000,000 rows vs 200 rows.

Oracle 11.2.0.4

  SELECT L.LINK_TYPE,

         L.LINK_ID,

         L.START_DATETIME,

         L.END_DATETIME,

         L.FROM_ITEM_TYPE,

         L.FROM_ITEM_ID,

         FP.PROPERTY_STRING FROM_NAME,

         L.TO_ITEM_TYPE,

         L.TO_ITEM_ID,

         TP.PROPERTY_STRING TO_NAME,

         L.COLL_ITEM_TYPE,

         L.COLL_ITEM_ID,

         CP.PROPERTY_STRING COLLECTION_NAME,

         P.START_DATETIME PROPERTY_START,

         P.END_DATETIME PROPERTY_END,

         P.PROPERTY_TYPE,

         P.PROPERTY_STRING,

         P.PROPERTY_VALUE,

         P.PROPERTY_DATE,

         P.ROW_ID,