Reputation: 135
I have a table with hash partitioning. I need to find out that in which partition a specific row placed. how can I do this?
Upvotes: 0
Views: 301
Reputation: 135
Finally I found the solution. This is the query:
EXPLAIN PARTITIONS SELECT * FROM table WHERE expression
Upvotes: 1