Re: Performance Expectations

Hey Marc,

I've run the EXPLAIN statement on the query and it does use the index.

I also use an "order by" on the table that does not include the indexed
field.  Would adding an index for the fields I'm ordering by help at all?

Thanks,
Derek

> I would suggest simply doing an EXPLAIN on your query and examining the
> output.  It will tell you whether your index is being used or not.  That's
> a big first step in determining what your optimal performance expectations
> should be.
>