View Single Post
Old 07-02-2007, 11:00 AM   #2
lark
 
lark's Avatar
 
Posts: n/a
My Photos: ()

Banked:
MK Cash: $

I am Worth:
MK Cash: $
Donate

Recent Blog: None

Default Indexes not showing

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.
  Reply With Quote