Thursday, September 15, 2011

Planning the SQL

Continuing from yesterday's post about the simple Firebird DB management tool that I wrote, I eventually found out how to display a query's plan. The answer was not to use the dbExpress components in order to connect to the database, but rather the IB components. These latter components are only for use in connecting to Firebird/Interbase databases and so have improved functionality at the cost of a less wide user base. This doesn't bother me as at the moment I am only supporting FB.

No comments: