Re: SELECT takes too long

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.