Re: slow search on INDEX?
None of these selects will use an index. 1. An index can not be used for LIKE '$something'. 2. An index will not be used if 1/3 of the entries match. 3. See #1. Jaime Teng wrote: >Hi, > >I have this table: >mysql> describe eventlog; >+-+--+--+-+-+-
slow search on INDEX?
Hi, I have this table: mysql> describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10)