whether 10 million rows or not - the current sollution will only ask for 6 - one additional row. Is that the time penalty you are talking about?WHAT IS WRONG? In example A all is OK.In example B we are not using the power of the Database Manager. WHY? The LIMIT clause was designed to tell the database engine: "Let find just X rows", then the database engine when it got the X rows stop searching and return the X rows. It improves the response time, since does not to continue searching! Now think in a 10 million row table and YOU KNOW you need only 5 rows!
--
Torsten
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
