Professional Web Applications Themes

Indexes not showing - MySQL

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...

  1. #1

    Default 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 Guest

  2. #2

    Default Re: Indexes not showing

    UKuser wrote: 

    you may not be using the index field in your query and that is why
    explain doesn't show it.
    lark Guest

  3. #3

    Default Re: Indexes not showing

    On 29 Jun, 14:58, lark <net> wrote: 




    >
    > you may not be using the index field in your query and that is why
    > explain doesn't show it.[/ref]

    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.

    UKuser Guest

  4. #4

    Default Re: Indexes not showing

    On 29 Jun, 15:28, UKuser <co.uk> wrote: [/ref]
    > [/ref]
    > [/ref]
    > [/ref]
    > [/ref]

    >
    > 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 -[/ref]

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

    Captain Guest

Similar Threads

  1. indexes in cs
    By Albert_Constantineau@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 1
    Last Post: August 14th, 09:41 PM
  2. using indexes
    By tragik in forum Coldfusion Database Access
    Replies: 0
    Last Post: January 9th, 07:03 PM
  3. Indexes
    By tomL in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 14th, 04:26 PM
  4. Two indexes?
    By Andy_Fielding@adobeforums.com in forum Adobe Indesign Windows
    Replies: 1
    Last Post: August 14th, 02:55 AM
  5. Do I need INDEXes when a UNIQUE has been set?
    By Laphan in forum ASP Database
    Replies: 5
    Last Post: July 29th, 04:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139