Interested to Buy Any Domain ? << Click Here >> for more details...
1. How actually index will work ?
2. Why do people prefer mostly bitmap index and btree index
in datawarehouse ?
3. If I use the column in aggrigate functions like
max,min,count and avg and if I have a index created on that
column, will it increases the performance ?
- 1 Answers
- 4567 Views
- IBM, I also Faced
- E-Mail Answers
Answer / mrs.priya
1.index file created separately(uses separate memory) apart
from the original file to increase performance
2. good performance
3. yes it increases the performance because index uses
separate memory
| Is This Answer Correct ? | 3 Yes | 0 No |
What is RULE-based approach to optimization ?
Why is oracle so popular?
What are oracle functions?
What different of iner joint & outer joint with example
How do we get field details of a table?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is recycle bin in Oracle?
How to invoke the original export import utilities?
How to apply filtering criteria at group level in oracle?
What is the database name in oracle?
Why is oracle database so popular?
What is an Oracle Instance?
Oracle General 
