Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nikhil
Global Index: A global index is a one-to-many relationship,
allowing one index partition to map to many table
partitions. A global index can only be a range partition!
Local Index: A local index is a one-to-one mapping between a
index partition and a table partition. In general, local
indexes allow for a cleaner “divide and conquer” approach
for generating fast SQL execution plans with partition pruning.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
internal architecture
what is grd?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you get actual data change values from previous transactions in oracle?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the use of recording information about current session?
What is the default port no on which sql server listens? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the steps you will take to improve performance of a poor performing query?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
