[To hackers this time]
At 12:11 27/10/00 +0900, Hiroshi Inoue wrote:
For example,LIMIT ALL means LIMIT 1 for optimizer and means
no LIMIT for executor.
Comments ?
It seems there's two possibilities:
(a) You know you will only use a limited number of rows, but you are not
sure exactly how
[To hackers this time]
At 20:59 26/10/00 -0400, Tom Lane wrote:
Hiroshi Inoue [EMAIL PROTECTED] writes:
Yes I want to give optimizer a hint "return first rows fast".
When Jan implemented LIMIT first,there was an option
"LIMIT ALL" and it was exactly designed for the purpose.
Well, we could
On Fri, Oct 27, 2000 at 09:21:23PM +1000, Philip Warner wrote:
[To hackers this time]
At 20:59 26/10/00 -0400, Tom Lane wrote:
Hiroshi Inoue [EMAIL PROTECTED] writes:
Yes I want to give optimizer a hint "return first rows fast".
When Jan implemented LIMIT first,there was an option