Home » RDBMS Server » Performance Tuning » can any one tell what is the order of execution of a query
can any one tell what is the order of execution of a query [message #230009] Tue, 10 April 2007 09:19 Go to next message
gvsunil1
Messages: 7
Registered: April 2007
Location: hyderabad
Junior Member

can any one tell what is the order of execution of a query.

means how the records will fetch from the data base....tell me with some example...
thanks in advance
sunil.

SELECT DISTINCT CM.ID, CM.SHIPMENT_NO, CM.CORRECTION_ID, CM.ORG_APP_STATUS, CM.DEST_APP_STATUS,
CM.ORG_STATION, CM.DEST_STATION, CM.INVOICE_TYPE, CM.CORRECTION_TYPE,
CM.REASON_CODE, UM.USERID, CM.CRTD_TSTMP, MTRX.AMOUNT, MTRX.LEVEL_ID,
CM.FHL_FLAG, 'INR' CURRENCY_ID, ROLE.BUSINESS_UNIT_ID, TM.TERMINALID
FROM TERMINALMASTER TM, USERROLES ROLE, USERMASTER UM,
ROLE_APP_MAPPING MAP, CORRECTION_APPR_MATRIX MTRX, LV_CORR_MASTER CM
WHERE TM.ACCT_CONTROL_STATION = ROLE.BUSINESS_UNIT_ID
AND UM.ID = ROLE.USERMASTER_ID
AND ROLE.ROLEID = MAP.ROLE_ID
AND MAP.APPROVAL_ID = MTRX.ID
AND SUBSTR(MTRX.CORRECTION_TYPE_CODE, 2) = SUBSTR(CM.INVOICE_TYPE, 2)
AND ROLE.USERMASTER_ID = --4010
3783
AND CM.STATUS IN ('P', 'H')
AND UM.IS_ACTIVE = 'Y'
AND CM.DEST_APP_STATUS = 'P'
AND TM.OPER_ADMIN_FLAG = 'O'
AND CM.ORG_STATION = TM.TERMINALID
AND CM.CORRECTION_TYPE='F'
AND CM.ORG_APP_STATUS = 'P'
ORDER BY ID, AMOUNT;
Re: can any one tell what is the order of execution of a query [message #230012 is a reply to message #230009] Tue, 10 April 2007 09:27 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

explain plan

Regards
Michel
Previous Topic: How can I do like this?
Next Topic: basics step
Goto Forum:
  


Current Time: Fri Dec 09 15:19:33 CST 2016

Total time taken to generate the page: 0.18691 seconds