Subject Re: Slow query help
Author markd_mms
--- In, Alexandre Benson Smith
<iblist@t...> wrote:
> I think you indices statistics are out of date, so the optimizer could
> not find the better approach.

Is there a way of telling? I've only just created this database,
created the indexes and then imported the data.

> Another consideration.
> Do you need all the outer joins ? The table slookslike normal linked
> tables, like Item and ItemInFormat, there is a possibility that you
> an Item without a format specified ? (and so on...)

I checked ITEM and ITEMINFORMAT and there aren't any entries in
ITEMINFORMAT that aren't in ITEM and vice versa.