what are the things that you consider while creating indexes
on partitioning tables?
- 1 Answers
- 4341 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What happens if the imported table already exists?
What is open database communication (odbc) in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
what are Triggers?
How to Truncate Table in Oracle
What happens if recursive calls get out of control?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Can a primary key contain more than one columns?
List the types of joins used in writing subqueries?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
How to get the Installed Oracle Version Information ?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Oracle General 
