MySQL Forums
Forum List  »  Partitioning

partioning and wildcards
Posted by: Pascal Knapen
Date: August 07, 2006 12:56AM

Hi,

I have partitioned my table (tbl_ngrams) alphabetically using range partioning (on ngram_name). When performing simple query's like:

explain partitions select * from tbl_ngram where ngram_name like 'cancer%';

It seems that mysql uses all partitions of course this is not what I want.
When I perform without the wildcard:

select * from tbl_ngram where ngram_name = 'cancer';

Mysql does just fine. It uses only the partition that contains the words starting with the letter 'c'.

Now my question: Is there a way I can work around this problem or is it just me ;-). Most of the query's uses wildcards so ... Some help please



Edited 1 time(s). Last edit at 08/25/2006 02:01AM by Pascal Knapen.

Options: ReplyQuote


Subject
Views
Written By
Posted
partioning and wildcards
4471
August 07, 2006 12:56AM
2180
August 21, 2006 10:46PM
2228
August 25, 2006 01:32AM
2360
August 25, 2006 01:40AM
2393
September 01, 2006 06:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.