Anyone know where wrapping all your fieldnames up in double quotes, reduces
performance in the query processing? Ie the Finance department is giving me
their SQL queries directly out of Crystal Reports and Seagate, and every
field and table name is wrapped in quotes and then Aliased for no particular
reason. Ie here is a sample of part of a query...some of these queries have
50 lines to them, and are taking forever to process in CF.
SELECT
"ITIN_LINE"."BRANCH_CODE", "ITIN_LINE"."PNR_NUM",
"ITIN_LINE"."ITIN_LINE_TYPE_CODE
FROM
"QTTC"."ITIN_LINE" "ITIN_LINE",
"QTTC"."BRACT_TICKET" "BRACT_TICKET",
"QTTC"."BRACT_TICKET_STATUS" "BRACT_TICKET_STATUS",
WHERE
"ITIN_LINE"."BRANCH_CODE" = "BRACT_TICKET"."BRANCH_CODE" AND
"ITIN_LINE"."PNR_NUM" = "BRACT_TICKET"."PNR_NUM" AND
"ITIN_LINE"."ITIN_LINE_NUM" = "BRACT_TICKET"."TICKET_ITIN_LINE_NUM" AND
"BRACT_TICKET"."STATUS_CODE" = "BRACT_TICKET_STATUS"."STATUS_CODE" AND
"BRACT_TICKET"."PURVEYOR_NUM" = "PURVEYOR_GROUP_W"."PURVEYOR_NUM"(+) AND
"BRACT_TICKET"."ACTION_TIMESTAMP" >= TO_DATE ('01-02-2003 00:00:00',
'DD-MM-YYYY HH24:MI:SS') AND
"CONSULTANT"."BRANCH_CODE" = '#FORM.BRANCH_CODE#'
ORDER BY
"ITIN_LINE"."BRANCH_CODE" ASC
Just wondering if taking out all the quotes will increase performance?
Phil
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
