> Can I have the query plan without executing the query ?
> If yes, what tools can I use to show the plan ?
> Currently I use marathon. It can display the plan only after executing
> the query.

The plan should be available when you prepare a statement. Perhaps
Marathon offers something just to prepare a statement?


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com