UKuser

On 29 Jun, 14:58, lark <ham...@sbcdeglobalspam.net> wrote:
> UKuser wrote:
> > Hi,
>
> > I'm having problems where I can clearly see indexes exist in
> > phpMyAdmin, but when I do an EXPLAIN statement they just don't appear.
> > For example one table is not using indexes even when I know a PRIMARY
> > key exists on it.
>
> > I've refreshed my SQL browser but still it doesnt appear. Is there
> > something obvious to do?
>
> > Thanks
>
> > A
>
> you may not be using the index field in your query and that is why
> explain doesn't show it.

Ah - I was using it in JOINS and the SELECT statement but not the
WHERE - I figured it must be used in JOINS but didnt get called up.