Re: slow search on INDEX?

2002-03-25 Thread Gerald Clark
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?

2002-03-24 Thread Jaime Teng
Hi, I have this table: mysql> describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10)