Skip to Content
0
Former Member
Jul 25, 2005 at 10:19 AM

ST05 - Explain SQL

139 Views

Hi all,

I'm using version 4.6C and I want to fine tune my SQL using the Explain SQL function, however I am having difficulty understanding what syntax to use in the tool.

Effectively I want to understand more about the performance of the following statement:-

select cpident tabkey

from bdcps

join on bdcp

where bdcpscpident = bdcpcpident

where bdcps~mestype = 'XXXXXXXX'

and bdcps~process = ' '.

However ST05 doesn't seem to understand what I am typing and keeps giving me an error, saying 'Change update/delete to select if possible', what format of the above statement would ST05 recognise?

Thanks in advance,

Stephen