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
- 4754 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 translate and replace in oracle?
How many anonymous blocks can be defined?
How to bring a tablespace online?
What are the different types of partitions in oracle?
How will you differentiate between varchar & varchar2?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
How do I uninstall oracle client from windows?
What is the usage of analyze command in oracle?
What is columnar storage what is the advantage?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to update a table row with a record?
how to truncate date and get only time part 9:20:00
Oracle General 
