Just installed 3.23.29-gamma and played around with fulltext indexes and
some other stuff. Ran into a weird problem that I hope you can shed some
light on.
Basically, a query's where clause has two parts joined by 'and':
select count(*) from ARTICLES where Publication_ID = 9 and Status
* Andrei Zmievski [EMAIL PROTECTED] wrote on 23.01.01 16:54:
mysql show keys from ARTICLES;
... [Andrei's mail trimmed down quite a bit]:
| ARTICLES | 1 | Publication_ID|1 | Publication_ID| A
|NULL | NULL | NULL | |
...
| ARTICLES |
Andrei Zmievski wrote:
On Tue, 23 Jan 2001, Gerald L. Clark wrote:
Why isn't it using index on the last query?
Because there isn't an index that contains both fields.
So it can't use separate indexes?
I guess the obvious solution would be to create an index on both of
those