Bruno Wolff III wrote:
Not according to the optimizer! Plus, this is not guaranteed to return the correct results.

For it to be fast you need an index on (stock_id, price_date) so that you can use an index scan.

I already said that such an index existed. In fact, it is the primary key of the table. And yes, I *am* analyzed!

The answers are guarenteed to be correct. See:

That's good to know. Thanks!


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to