Partitioned table usage question

I have a table that is currently partitioned on a date column ( partitioned at month boundaries). Using explain plan how can I determine that the optimizer is looking for data from a specific partition ( i.e. partition pruning) based on the query I execute. e.g I need to know that when I select data for 12/15/1998 the optimizer looks only in the December partition and then uses the index on the date column to find the exact row I need. Thanks,

Arun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 15 1998 - 13:52:03 CST