Interested to Buy Any Domain ? << Click Here >> for more details...
what are the things that you consider while creating indexes
on partitioning tables?
- 1 Answers
- 4834 Views
- I also Faced
- E-Mail Answers
Answer Posted / gautam choudhury
1) If the table partitioning column is a subset of the
index keys, use a local index. If this is the case, you are
done.
If this is not the case, continue to guideline 2.
2) If the index is unique, use a global index. If this is
the case, you are done. If this is not the case, continue
to
guideline 3.
3) If your priority is manageability, use a local index. If
this is the case, you are done. If this is not the case,
continue to guideline 4.
4) If the application is an OLTP one and users need quick
response times, use a global index. If the application is a
DSS one
and users are more interested in throughput, use a local
index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Calculate difference between 2 date / times in oracle sql?
What do you mean by merge in oracle and how can we merge two tables?
How does the on-delete-cascade statement work?
What are the types of partitions in oracle?
What is a schema in oracle?
What is key preserved table?
How to use null as conditions in oracle?
How to define a variable of a specific record type?
What is recycle bin in Oracle?
How to create a testing table in oracle?
How to execute the package in oracle?
How to resolve the ORA-39133 error in Oracle?
How to test null values?
What are temporal data types in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
