Help (Serial, Fragments:ALL) Again

Sorry about the confusion the previous post was supposed to say it is running fine on 7.2 SE but not on online. 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 on the index the number of pages allocated is 13012 and the number of pages used is 10578 to I don't know how it could be fragmented. The database has only one extent. The set explain is as follows select * from flmastpymt where pa_prechk_date = "07/1597" and pa_prechk_code = "00:45" and pa_payee_code = 70102 and pa_host_status = 'N' and pa_check_number is NULL Estimated cost :1 Filters: (family.flmastpymt.pa_payee_code = 70102 AND (family.flmastpymt.pa_host_status = 'N' AND family.flmastpymt.pa_check_number is NULL) ) (1) Index Keys: pa_precheck_date pa_precheck_time pa_receipt_id (Serial, fragments: ALL) Lower Index Filter: (family.flmastpymt.pa_prechk_date = 07/15/199 AND family.flmastpymt.pa_prechk_time = datetime(00:45) hour to minute) -- 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