Subject | SQL plan in TIBOQuery |
---|---|
Author | hubert_krukowski <hubert@agb.com.pl> |
Post date | 2003-02-03T14:29:19Z |
Hi,
Is there any way I can access (read and write) the SQL plan for the
TIBOQuery? The optimizer comes up with some horrible one and if I do
not change it I end up waiting 10 minutes for a query to finish. The
query component is linked to DevExpress grid and its
OrderingLinks/OrderingItems are set at runtime to facilitate grid
sorting.
Any ideas?
Regards,
Hubert Krukowski
Is there any way I can access (read and write) the SQL plan for the
TIBOQuery? The optimizer comes up with some horrible one and if I do
not change it I end up waiting 10 minutes for a query to finish. The
query component is linked to DevExpress grid and its
OrderingLinks/OrderingItems are set at runtime to facilitate grid
sorting.
Any ideas?
Regards,
Hubert Krukowski