RV: Show query plan?

Posted in 2000

DMZZ — Thu, 6 Jan 2000 14:05:39 -0300 — source: Informix-list mailing list archive (1991-1998)

Use SET EXPLAIN ON: the information you are looking for is logged in a file UserName.out in NT or sqexplain.out in Unix. --Diego Mezzera ----- Mensaje original ----- De: Sunil Bhaskarla <sunil@intelus.com> Enviado: Jueves, 06 de Enero de 2000 10:49 a.m. Asunto: Show query plan? > How can I see what the query engine is doing behind the scenes when I type a query? In other words, how can I see its query execution plan (creating temp work tables and such)? > > I remember in SQL Server its something like SHOW QUERY PLAN ON... > > > Thanks, > Sunil > >