| View previous topic :: View next topic |
| Author |
Message |
Bob Murdoch
Guest
|
 Posted: Wed Feb 16, 2005 8:26 pm Post subject: How to get query plan |
 |
|
I'm converting an application from the Interbase Express components to the
ADO Express components (Delphi 5).
Is it possible to retrieve the query plan from an ADO component after
prepare?
tia,
Bob M..
|
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Wed Feb 16, 2005 10:43 pm Post subject: Re: How to get query plan |
|
|
I assume you are still using InterBase 7.5 as the database. If so, the answer is no.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
Bob Murdoch wrote:
| Quote: | I'm converting an application from the Interbase Express components to the
ADO Express components (Delphi 5).
Is it possible to retrieve the query plan from an ADO component after
prepare?
tia,
Bob M..
|
|
|
| Back to top |
|
|
Bob Murdoch
Guest
|
| Posted: Wed Feb 16, 2005 11:51 pm Post subject: Re: How to get query plan |
|
|
Bill,
"Bill Todd" <no (AT) no (DOT) com> wrote
| Quote: |
I assume you are still using InterBase 7.5 as the database. If so, the
answer is no.
|
Sorry, I should have mentioned - in this case, I'm going to be using Oracle
8i. However, I'd like to make it generic, hence the ADO components.
Bob M..
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Thu Feb 17, 2005 1:59 am Post subject: Re: How to get query plan |
|
|
There is no generic way that I know of to get a query plan. There is
nothing in the SQL standard that covers getting a plan so every vendor
does it differently.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
