--- 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?
dpi.device_id is not constant. You'd be better off with this index for your query: CREATE INDEX dpi3 ON device_perf_interval( interval_type, interval_duration ); ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------