what are the things that you consider while creating indexes
on partitioning tables?
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
What is save point in oracle database?
What is a partition in oracle?
How to connect ms access to oracle servers?
Is oracle a language?
When system tablespace is created?
Explain the difference between sql and oracle?
What do you mean by redo log file mirroring?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is a nvl function?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Can a formula column referred to columns in higher group ?
Explain mutating triggers.
What is literal?
What happens if variable names collide with table/column names?
How to add another datafile to a tablespace?