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
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a crs resource?
What is transparent data encryption? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
internal architecture
What is the importance of a recovery model? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is dbcc? : sql server DBA
What is fill factor? : sql server DBA
