Indexes not showing

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

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.

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.

On 29 Jun, 15:28, UKuser <spiderc...@yahoo.co.uk> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

I certainly might get used in JOINS. It depends on what the optimiser
decides is the best thing to doin this particular situation.