How to do explain with sql optimizer on select from session table

Toad for IBM DB2
1

Hi,

I would like to do explain on a SQL request with session table.
How could I do this with toad for db2 ?
The problem is that SQL optimizer want just one sql request…
I use the v5.0.4.731.

Best regards,
Bruno

2

Hi Bruno,
I’m not familiar with sql optimizer for DB2.
Try to look at video prepared for SQL Optimizer for SQL Server
http://sqloptimizersqlserver.inside.quest.com/index.jspa
or open a support ticket at support.quest.com
thanks

3

Bruno,
Can you give more details of what you mean by
“explain on a SQL request with session table.”
Thanks
Jeff