Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help: partitioning question
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 - 11:27:19 CST