I'm working on a project and I got stuck at one point!
I'm using PHP 4.3 and Firebird 1.0 Database. I can to connect to the database server and run some queries but I'm not able to get the query plan used to perform the sql query. Is there any php function which returns the plan not just the query result???? If there isn't...how can I resolve this problem?
Please help me, I need a solution ASAP
Queries work fine in InterBase, I can get the result of the SELECT... statement, but I just want to know what execution plan InterBase uses.
There is a command line utility ISQL. When I type in a query, It displays the plan as well, not just the query.
ex. I connect to my database with isql and issue the select query. This way I can get the ex. plan and the result as well.