Subject | query optimization feedback/tools? |
---|---|
Author | Emile Snyder |
Post date | 2004-09-09T21:45:02Z |
Hi all,
I've looked in the IB6 Language Reference and Operations Guide and can't
seem to find what I'm after.
As a user migrating from mysql, I'm used to being able to do 'explain
select ...<query guts>...' and see some information about which parts of
the query are using indices, how many rows in the result table they're
responsible for, etc.. I found a few mentions of using PLAN in firebird
select queries, but no examples.
Can anyone point me to some info on "the firebird way" to do this sort
of thing?
thanks,
-emile
+----------------------------------------------------------------------
"This `telephone' has too many shortcomings to be seriously considered
as a means of communication. The device is inherently of no value to
us." -- Western Union internal memo, 1876.
+----------------------------------------------------------------------
I've looked in the IB6 Language Reference and Operations Guide and can't
seem to find what I'm after.
As a user migrating from mysql, I'm used to being able to do 'explain
select ...<query guts>...' and see some information about which parts of
the query are using indices, how many rows in the result table they're
responsible for, etc.. I found a few mentions of using PLAN in firebird
select queries, but no examples.
Can anyone point me to some info on "the firebird way" to do this sort
of thing?
thanks,
-emile
+----------------------------------------------------------------------
"This `telephone' has too many shortcomings to be seriously considered
as a means of communication. The device is inherently of no value to
us." -- Western Union internal memo, 1876.
+----------------------------------------------------------------------