Re: SELECT takes too long

mikehunt@sophocles.algonet.se (Mike Johnson) wrote: >Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM wrote: >: >: Does anyone know why dropping and re-creating table restores responds >: time? >: >Yes. By your own admission you are updating *many* of the records in >your table each day. When you do this, the index and table become >fragmented and badly structured. Informix tell you about this in the >documentation. >The solution, as you have found, is to do a daily reorganisation >of the tables. >Mike. That is correct. If you have the disk space available, then you might want to alter one of your indexes to cluster, and then back to normal. This in effect will force a reorganization of your tables. +--------------------------------------+ | Partha Dutta | | pdutta@vsol.com OR pdutta@airmail.net| +--------------------------------------+