MySQL Forums
Forum List  »  Partitioning

Re: How to query a specific partition using list partitioning mechanism??
Posted by: Mattias Jonsson
Date: February 20, 2009 12:15PM

There are no syntax for specify particular partitions, but you can just set the WHERE clause to 'Client_ID = 1' or 'Client_ID in (<list as in partition definition>)' which will do partitioning pruning so it will only search that partition.

so

SELECT * FROM `test`.`clientdetails` WHERE Client_ID = 1;

This will prune away all other partitions and only scan partition 'tr'.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to query a specific partition using list partitioning mechanism??
2943
February 20, 2009 12:15PM


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.