Add/Drop Partitions

[yxez]

Global indexing means 1 index for the entire table.

Hi dear....i forgot my partitioning knowledge because I haven't read
it again for a long time. I have just created a partitioned table
and a global index and did not bother about other options.

What is the advantage/disadvantage again of a Global Index vs
Global Partitioned Index vs a Local index in a Partitioned Table?

If i relate it to a partitioned table:

A. Non-partitioned, index by travel_date and fullname
---------------------------------------------------
Select fullname from TRAVEL where travel_date='01-DEC-93'
and fullname like 'BIN%LADEN%OSAMA%'

B. Partitioned by travel_date, Global index by travel_date and fullname
-------------------------------------------------------------
Select fullname from TRAVEL PARTITION(TRAVEL1993)where
and fullname like 'BIN%LADEN%OSAMA%'

Which do u think runs faster? Or is partitioning just for ease
in managing large tables and not really performance.

Is it the same with Partitioned Indexes? They have same
performance benefit with non partitioned index but only segment management differs.


Thanks