Help (Serial, Fragments:ALL)

Posted in 1997

kevin patten — 7 Aug 97 15:01:49 GMT — source: Informix-list mailing list archive (1991-1998)

We've got a problem with 7.20 Online and would like to know if you have the answer. We are running a query against a database to process checks (approx. 400) and it is taking 16 hours. This table has approximately 2 mil. rows. The explanation of the query says a cost of 1 but the index keys says (Serial, fragments: ALL). HELP. What does fragments:ALL mean? How do we fix it. BTW we do not see this problem in 7.2 Online. -- Kevin Patten Technical Support Manager Florida Association of Court Clerks 3375 N.E. Capital Circle Suite 1 Tallahassee, Fl. 32308 904-921-0808 http://www.flclerks.com patten@flclerks.com