Re: AW: Slow Select

There is a new feature in version 11 which will automatically produces the low statistics and high distributions for the dbimport. In short the create index automatic creates the low and high on the lead index key in version 11. John Did you run an update statistics after dbimport? Joerg Volz ________________________________ Von: ids-bounces@iiug.org im Auftrag von MICHAEL MEIER Gesendet: Fr 18.01.2008 11:05 An: ids@iiug.org Betreff: Slow Select [10977] We have ported data from SE 7.X to IDS10 via dbimport-tool. There is a table with about a million records. In there is a serial-field (ID) and a num= eric field (SYSTEMNR) with a kind of key. On both there is a index. if ask t= he ids select * from table where ID=3D4711it takes less than a second select * from table where SYSTEMNR=3D4711takes about a minute!!! select * from table where SYSTEMNR>4710 and SYSTEMNR<4712it takes less than a second What the hell is this ????? ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! IT Handel und Beratung J=F6rg Volz Bernhard-Fr=FCh-Str. 7 77855 Achern GERMANY Tel: 07841-681651 Fax: 07841-681654 Mobil: 0170-2989757 Ust-ID: DE201383541 http://www.it-volz.de ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!=