Re: How to use Partition in Query

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 11 Apr 2006 04:51:38 GMT
Message-Id: <pan.2006.04.11.04.51.38.786811@sbcglobal.net>

On Mon, 10 Apr 2006 12:52:34 -0700, Lucky wrote:

> 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.

How is the table partitioned? Hash? List? Ordered by a column? Ways of partitioning many are, young padawan.

-- 
http://www.mgogala.com

Received on Mon Apr 10 2006 - 23:51:38 CDT