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 o
* 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 | |
>...
> | ART
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 fields, but I will also need to h
Andrei Zmievski wrote:
>
> 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 ARTICL
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 =
