sql - Oracle Table Partitioning -

sql - Oracle Table Partitioning -

suppose have next table:

table name: item columns: id, item_num, item_color, item_spec, item_status

and item table (list) partitioned on item_status column. values item_status can have are: active, inactive, suspended id pk, hence there index on it.

now, when execute query:

select * item item_color="green"

please help me with 1. how oracle determine partition go to, since partition not on item_color column? 2. above query not benefit partitioning @ all? 3. necessary sql queries have partitioned column in clause benefit partitions. 4. how utilize indexes in case of partitions?

if there no way determinate if query needs info coming specific partitions, oracle must @ partitions of table.

the concept of partition can't explained simple answer, improve read documentation have understanding.

anyway before getting sure have performance problems first, if not leave tables unpartitioned.

go

http://docs.oracle.com/cd/e11882_01/server.112/e25789/schemaob.htm#cfagceci or http://docs.oracle.com/cd/e11882_01/server.112/e25554/parpart.htm#i1007993 or http://docs.oracle.com/cd/e11882_01/server.112/e16638/data_acc.htm#i21879.

sql oracle database-design partitioning