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 Posted / 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 |
Post New Answer View All Answers
Why do we need oracle client?
How to call a stored function with parameters?
How index is implemented in oracle database?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the string concatenation operator in oracle?
How to insert multiple rows with one insert statement in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Explain the use of inctype option in exp command.
How to speed up webrick?
Explain self joins in oracle?
What is pragma autonomous transaction in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is the difference between primary key and unique key and foreign key in oracle?
Please explain oracle left join with an example?
What is the order of defining local variables and sub procedures/functions?