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
- 4933 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 is the difference between substr and instr?
How do I find the database name in oracle?
which sql command we can use to get a print out from oracle?
What is an oracle wallet?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What the is the diff between local index and global index. give some example.
What is different bet native dynamic sql and Dbms_Sql?
How to calculate date and time differences in oracle?
How can windows applications connect to oracle servers?
How to declare a local variable?
What is a read only transaction in oracle?
How to specify default values in insert statement using oracle?
Oracle General 
