Re: Help (Serial, Fragments:ALL)

kevin patten wrote: > > 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). A cost of 1? Hmmmm. Here's a question. When was the last time that you ran update statistics against this table? > > HELP. What does fragments:ALL mean? How do we fix it. Sounds like the table has been fragmented. The query is looking at each table fragment serially.