On Tue, Jan 07, 2003 at 10:44:15 -0200,
Felipe Schnack <felipes(at)ritterdosreis(dot)br> wrote:
> Why? I don't understand. If I create a query and want just the first
> row from it, wouldn't speed up things a lot just adding "LIMIT 1" in the
> end of the query?
That depends on the query. For some queries you will only see a small
speed up. It is also possible for limit to effect the optimization results
in a way that ends up slowing things down (though that should be rare)
because an inferior plan ends up being chosen.