Bruno Wolff III wrote:
If you want both the max and the min, then things are going to be a bit
more work. You are either going to want to do two separate selects
or join two selects or use subselects. If there aren't enough prices
per stock, the sequential scan might be fastest since you only need to
go through the table once and don't have to hit the index blocks.

It is still odd that you didn't get a big speed up for just the min though.

I found I'm suffering from an effect detailed in a previous thread titled

Does "correlation" mislead the optimizer on large tables?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to