SQL Performance - CA PPM - Restrictive Conditions

 Begin queries with the most restrictive conditions

SELECT SRMR.FULL_NAME, AV.SLICE_DATE,AV.SLICE FROM SRM_RESOURCES SRMR
JOIN PRJ_BLB_SLICES AV ON SRMR.ID=AV.PRJ_OBJECT_ID AND AV.SLICE_REQUEST_ID=7 WHERE SRMR.ID=1
ORDER BY SRMR.FULL_NAME, AV.SLICE_DATE

Instead of


SELECT SRMR.FULL_NAME, AV.SLICE_DATE,AV.SLICE FROM PRJ_BLB_SLICES AV
JOIN SRM_RESOURCES SRMR  ON SRMR.ID=AV.PRJ_OBJECT_ID AND AV.SLICE_REQUEST_ID=7 WHERE SRMR.ID=1
ORDER BY SRMR.FULL_NAME, AV.SLICE_DATE


In terms performance i use first query, because slice table will have more data generally.