This is a discussion on Re: Whatcha' wanta have????? within the Informix forums, part of the Database Server Software category; --> Madison Pruet wrote: > As a mild diversion from the IDS-DB2 conversion thread, its time for one of > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|