"Kevin Grittner" wrote:
> WITH x AS SELECT * FROM x ORDER BY d.data_id;
It ate part of what I had on that line. (Note to self: don't use
angle-bracketing in posts.)
Trying again with different punctuation:
WITH x AS [original query] SELECT * FROM x ORDER BY d.data_id;
-Kevin
--
Sent
[Please don't top-post; it makes the discussion hard to follow.]
tuanhoanganh wrote:
> Greg Williamson wrote:
>> Did you run an analyze on the table after building the new
>> indexes? The row estimates seem to be off wildly, although that
>> may be a symptom of something else
I think that'
