Re: feature suggestion - indexes with "where" clause or similar

[Jeremy Zawodny]

On Tue, Nov 19, 2002 at 07:12:27AM +1100, Dean Harding wrote:
> Actually, it's a slightly different problem - a very uneven distribution
> of values on a column, not a small number of possible values like a
> bitmap index is for.

Exactly.

> In my opinion, this is a pretty useless feature, I mean the whole
> *point* of the optimizer is to see things like that and do a full table
> scan when it's going to be faster.

Well...

> I guess I can see the point if the row is only *added* to the index if
> it matches the WHERE clause.  That'd speed up the index management as
> well.

Bingo.  That's it.  Speed up, save space, save CPU, etc.

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 104 days, processed 2,262,358,069 queries (250/sec. avg)