[postgis-users] optimize query

[Gold, Jack L (US SSA)]

I'm finding a search query we wrote is running really slow.  Any ideas on how to optimize this better?  Or is this the best I can do?

SELECT ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(66.12, 37.32), 4326),ST_SRID(rast))) FROM dted_elevations WHERE ST_Intersects(rast, ST_Transform(ST_SetSRID(ST_Point(66.12, 37.32), 4326), ST_SRID(rast)));

--Jack Gold


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120522/902fb791/attachment.html>