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

How to start an oracle instance?

799


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4324


What is a select query statement in oracle?

735


How to estimate disk space needed for an export job?

788


How to rename a tablespace in oracle?

868


How to connect ms access to oracle servers?

752


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

884


material view and view disadvantages?

829


definition of cluster and non-clustered index?

2715


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1092


What is Segment Advisor in Oracle?

864


What is merge statement used for?

788


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1868


How much memory your 10g xe server is using?

839


what happened to the global index when I truncate the data in one of the partition?

1744