Check which row is in which partition
Is there any way of checking which record is present in which partition??
I have a table A (a1, a2, a3) which is range partitioned. Table A has 40 million rows. I need to check in which partition row n is. How to do this??
Thanks in advance!!