Indices do not seem to work for OR queries

2003-02-28 Thread Henning Schulzrinne
--+--+-+ | person | ref | email1,email2 | email1 | 101 | const |1 | Using where | ++--+---++-+---+--+-+ I'm curious why this is. (In general, I have been surprised by how often indices are no

Re: ADD INDEX hangs

2003-01-27 Thread Henning Schulzrinne
Very unlikely. I'm only using 7% of the disk capacity. gerald_clark wrote: Have you run out of free disk space? Henning Schulzrinne wrote: Description: ADD INDEX for a modest-sized table hangs. The temporary table gets created, but then the process forever hangs on lwp_cond

ADD INDEX hangs

2003-01-27 Thread Henning Schulzrinne
has lots of indices, including a full-text index. >How-To-Repeat: alter table add index (number(4)) >Fix: >Submitter-Id: >Originator:Henning Schulzrinne >Organization: Dept. of Computer Science, Columbia University >MySQL support: none >Synopsis: A