Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to use Partition in Query
Hi All,
I have a table which has more than 10 partitions.Now I want to query the table but don't want a full table scan.I want to fetch results from 2 partiitions (suppose partition A and B).How can I do that.Can I use multiple partition name in my query.
All the reply will be highly appreciated.
Thanks in Advance. Received on Mon Apr 10 2006 - 14:52:34 CDT