Re: Dynamic Explain plan option in version 10

Posted in 2006

Summary

Discussion of the version 10 dynamic explain feature. Fernando Nunes said he believed a feature request existed and that the plan should be available through SQL for any user. Paul Watson said it was surely not easy to do. Keshav reported that IDS Cheetah had added SET EXPLAIN TO FILE with a file name, visible to beta users, and said onmode -Y issues were known.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Performance & Tuning

Fernando Nunes — Thu, 02 Nov 2006 23:55:19 +0000 — source: Usenet: comp.databases.informix

Paul Watson wrote: > It would be nice if we had the V8 capabilities for SQLEXPLAIN, i.e. the > ability to specifiy where the file is written. I believe this is in as a > feature request > I believe this is a registered feature request, and I believe we may see it in the future. But I'd say it's not enough... The explain plan should be available through SQL... The "trick" that Art mentioned should not be needed. Any user with SQL access should be able to see the query plan of his last query... -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to Fernando Nunes

Paul Watson — Thu, 2 Nov 2006 20:41:00 -0600 — source: Usenet: comp.databases.informix

I'm sure if it was easy to do it would have been done by now Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Fernando Nunes [mailto:spam@domus.online.pt] > Posted At: 02 November 2006 17:55 > Posted To: comp.databases.informix > Conversation: Dynamic Explain plan option in version 10 > Subject: Re: Dynamic Explain plan option in version 10 > > > Paul Watson wrote: > > > It would be nice if we had the V8 capabilities for SQLEXPLAIN, i.e. > > the ability to specifiy where the file is written. I > believe this is > > in as a feature request > > > > I believe this is a registered feature request, and I believe > we may see it in the future. But I'd say it's not enough... > The explain plan should be available through SQL... The > "trick" that Art mentioned should not be needed. > Any user with SQL access should be able to see the query plan > of his last query... > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...

↪ replying to Paul Watson

keshava.news@gmail.com — 3 Nov 2006 14:52:26 -0800 — source: Usenet: comp.databases.informix

we've added the following to IDS Cheetah (next release). SET EXPLAIN TO FILE '/tmp/myfile'; Those on the Beta program can see this now. Others will have to wait for OpenBeta. We're aware of onmode -Y issues. will keep you posted. cheers, Keshav.

↪ replying to Paul Watson

Fernando Nunes — Sat, 04 Nov 2006 01:10:22 +0000 — source: Usenet: comp.databases.informix

Paul Watson wrote: > I'm sure if it was easy to do it would have been done by now > You have a point... Of course is much easier to talk about it then to implement it. But I'm sure we'll see a lot of difficult to implement features in the near future... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...