Chris Eich <[EMAIL PROTECTED]> wrote:
I realize that but thought that device_id would be included because of the d.device_id=dpi.device_id term. What am I missing?
The query selects _all_ values of device_id from device_perf_interval, and for each tries to find a matching record in device. How would an index on device_perf_interval(device_id) help here?
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
