Have you tried Craigs Planalyzer and put each seperate query
into them?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Still didn't have any feedback regarding optimization support. The
> issue is: how can I analyze how much time IB/FB spends with the
> execution of a number complex queries involving UDFs and stored
> procedures to get a hint why those queries are relatively slow?
>
> No one out there having an idea on this or is this just the wrong
> group?