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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How would you go about verifying the network name that the local_listener is currently using?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how to restore files with rman?
What are the different types of indexes available in sql server? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
internal architecture
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is a correlated sub-query? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you schedule a job in database?
What is fill factor? : sql server DBA
how can a session indicate its interest in receiving alerts?
