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
- 4590 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 are group functions in oracle?
How to connect to oracle using service name instead of sid?
How to return top 5 rows in oracle?
How do I know if oracle client is installed on windows?
What is SAVE POINT ?
How do I start tns listener?
What is the difference between a user and a schema in oracle?
What are the benefits of ordbms?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
What is oracle data type?
Explain about integrity constraint?
What is the maximum limit on the number of columns in a table?
Oracle General 
