MySQL Forums
Forum List  »  Partitioning

Re: Possible to Partition Strings ?
Posted by: Phil Hildebrand
Date: April 27, 2008 08:46PM

For detailed info on the differences between a full text search and and typical character based search against a column for a subset of that string, you'll probably want to go through the docs more in detail.

http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

You might also post your questions directly on the full text forum:
http://forums.mysql.com/list.php?107

In general, a full text index will index all words in a column / file, etc. It will also allow for different kinds of searches that you can get in a search accross a partitioned table. It would be faster because the optimizer could still use the full text index for searching a value 'XZY' within a larger string in most cases, whereas an index (even primary key) on a partitioned table with the same search (%xzy%) would still require a full table/index scan.

Note: I'm not really a MySQL full text index expert... I'm more familiar with full text queries within SQLServer, or externally to indexers like google or fast...

Options: ReplyQuote


Subject
Views
Written By
Posted
4219
April 22, 2008 04:47PM
2901
April 23, 2008 03:30PM
2735
April 23, 2008 04:15PM
Re: Possible to Partition Strings ?
4775
April 27, 2008 08:46PM


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.