Re: Why does the optimizer do this ? uhmmmmmm

At 06:43 PM 3/14/96 -0500, Jorge Torralba wrote: }Something I noticed with Set Explain; } }Index: } }Unique Index: location_pk, bldg_no, div_number } } }QUERY: }------ }select location_pk, loc_type from raw_inventory where location_pk = }311006511 } }Estimated Cost: 2 }Estimated # of Rows Returned: 3 } }1) informix.raw_inventory: SEQUENTIAL SCAN } Have you done an UPDATE STATISTICS lately? -- Ying-tong-iddle-i-po!