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
- 4853 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 |
where we have to use ON clause and where we have to use USING clause in JOINS
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is an oracle user account?
How do I limit the number of oracle database connections generated by weblogic server?
where do i find oracle interview questions.
What is user managed backup in Oracle?
Without giving condition how to retrieve the unmatched records from table.
When do you get a .pll extension in oracle? Explain its importance
What do you mean by cdb and pdb in oracle 12c?
How do we get field detail of a table?
How to create a temporary table in oracle?
Oracle General 
