Dmitry Yemanov <firebi...@yandex.ru> писал(а) в своём письме Thu, 02 Jan 2014 15:55:57 +0400:
> > This makes it necessary to allow the FIRST ROWS mode when it's needed. > I'm proposing the following: > > 1) FIRST ROWS mode is implicitly used when the FIRST / ROWS clause is in > game. Also, FIRST ROWS mode is implicitly used for EXISTS / ANY > subqueries. > > 2) An explicit clause is introduced to force the non-default mode (ALL > ROWS for FIRST-claused queries and FIRST ROWS for other queries). Hating > Oracle-like pseudo-comments with embedded hints and preferring explicit > syntax, I suggest (inspired by DB2): > > SELECT ... > [OPTIMIZE FOR {FIRST | ALL} ROWS] > Syntax for tips aka DB2 I like more, but it reduces the portability of SQL queries themselves between different DBMS, while syntax Oracle (as a comment) does not have this disadvantage. If all the tips are localized in one place it may slightly alleviate this problem. About the default optimization as ALL ROWS fully agree. ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel