Re: AW: SQL versus READ for sequential processing

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

You should run a database monitor to verify which engine ran you query. 
You can do this from Navigator quite easily, from the SQL statement 
processor. There will be information there about all manner of things, 
including which engine. Read the help text to learn what you are looking 
at and where to find the information.

Just because a table was created with DDL, there is no guarantee that 
SQE will be used to run the query - the way a table is created is NOT 
one of the criteria for which engine is used.

Regards
Vern

Åke Olsson wrote:
> Not that in my example the table used for the SQL test was created with SQL Create Table. It should have used the SQE.
>
> It ran slowly anyway.
>
>
> Med vänlig hälsning / Best regards
> Åke Olsson
>  
> Pdb DataSystem AB
> Box 433   SE 551 16  Jönköping   Sweden   visit: Brunnsgatan 11
> phone: +46 (0)36 342976   mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29
> ake.olsson@xxxxxx    www.pdb.se
>
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient,
> please notify the sender immediately by return e-mail, delete this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>