Madison Pruet wrote:
> As a mild diversion from the IDS-DB2 conversion thread, its time for one of
> my more favorite exercises. ;-)
>
> We are nearing the end of the coding cycle for IDS 9.5. We've got a whole
> bunch of really cool stuff in place and - well - its time to get input from
> you guys as to what you want to see in the 9.6 release.
>
> Now, I know that everyone's favorite thing is going to be "marketing", but
> I'm in development. So I need to talk features and functionality. So feel
> free to send them on in.

Automatically use SET OPTIMIZATION FIRST_ROWS when using SELECT FIRST n,
where n is a small percentage of the total number of records in the table.

I guess the opposite might be applicable as well -- Automatically use SET
OPTIMIZATION ALL_ROWS when NOT using SELECT FIRST n. Just in case someone
forgot to switch off FIRST_ROWS optimisation. ;-)

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+


sending to informix-list