MySQL Forums
Forum List  »  Partitioning

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


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

Written By
partioning and wildcards
August 07, 2006 12:56AM
August 21, 2006 10:46PM
August 25, 2006 01:32AM
August 25, 2006 01:40AM
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.