AUTO INDEX

hello i am seeing more queries in version 11 that use the auto index feature than i ever recall seeing in version 10. it seems like the optimizer behaves differently but have not seen much in the literature about it. what is strange is that it is auto indexing on tables that are small (anywhere from 50 rows to a couple thousand) and also it is indexing fields like active, where there are only two possible values. any insight? thanks

On Mon, Oct 11, 2010 at 9:24 PM, Tom Lehr <tomcaml@gmail.com> wrote: > hello > > i am seeing more queries in version 11 that use the auto index feature > than i ever recall seeing in version 10. it seems like the optimizer > behaves differently but have not seen much in the literature about it. > what is strange is that it is auto indexing on tables that are small > (anywhere from 50 rows to a couple thousand) and also it is indexing > fields like active, where there are only two possible values. any > insight? > thanks > > Hello. Personaly I haven't noticed it... I've probably seen AUTOINDEX a couple of times and it's possible that one was on 11.5. If you feel it's choosing badly, it would be nice if you could open a PMR and/or give us a few examples. I always felt that AUTOINDEX was a "last resource" kind of query plan. Maybe it means your tables would benefit from some more indexes... But I don't have any more info on this than a normal user... Also, the version would be helpful... Regards. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...