Re: How to find out programmatically whether a query on a view will use an index?
This is a discussion on Re: How to find out programmatically whether a query on a view will use an index? within the pgsql Sql forums, part of the PostgreSQL category; --> > > Is there no way to get a machine readable query plan? > > No, and no such ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 10:52 AM
| ||||
| ||||
 Re: How to find out programmatically whether a query on a view will use an index? > > Is there no way to get a machine readable query plan? > > No, and no such API is likely to be defined in the future either, > because we reserve the right to change plan structures at any time. How about a list of the indices used in a query? That alone would already be very useful. Martin ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
 |
« Re: How to find out programmatically whether a query on a view will use an index?
|
Value specific sequences? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:54 PM.
