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
What happens on checkpoint? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the difference between dropping a database and taking a database offline? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is dbcc? : sql server DBA
what is asm?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what are the differences of where and if in SAS?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What the different topologies in which replication can be configured? : sql server DBA
which background process invoke at the time of upgradation tell me???
