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 ?
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 difference between a formal and an actual parameter?
What happens if you lost a data file?
Define oracle database
What is raw datatype?
What is the relation of a user account and a schema in oracle?
How to list all user accounts in oracle?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
What is query image?
what is null value?
Explain a data segment?
How to convert numbers to characters in oracle?
if you ctreate table identity