partitioning question - anybody know?

In order for a partition to be accessed by a SQL query, does the query have to reference the partition key directly, or does it not matter?

For example, if I define my_table as:

id number
name varchar2(40)

and I partition on id, would the following querys *both* access an individual partition, or only the first one?

SELECT * from my_table
WHERE id = 1;

SELECT * from my_table
WHERE name = 'Joe';
or would this second query access *all* partitions, because I am not referencing the partition key directly?

I wouldn't think it would matter which columns are referenced in the WHERE clause, but I remember reading somewhere that it does...

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 15:28:43 CST