> There are over 1.7 million records in this database. Using the free

version of IB Expert, it doesn't allow me to view the execution plan. Is
there a way of viewing this maybe from a dos prompt.

>

The command line tool "isql" allows you to view the plan.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com