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


Please Help Members By Posting Answers For Below Questions

What is save point in oracle database?

835


What is a partition in oracle?

633


How to connect ms access to oracle servers?

624


Is oracle a language?

600


When system tablespace is created?

687






Explain the difference between sql and oracle?

686


What do you mean by redo log file mirroring?

634


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1946


What is a nvl function?

641


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.

1943


Can a formula column referred to columns in higher group ?

2166


Explain mutating triggers.

672


What is literal?

673


What happens if variable names collide with table/column names?

681


How to add another datafile to a tablespace?

656