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
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,