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
- 4598 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 |
how to we delete a row using varray
How to use an explicit cursor without open statements?
Explain user account with reference to oracle.
what are stored procedures?
How to write a query with a full outer join in oracle?
How many types of segments in Oracle?
Why do you create or replace procedures rather that drop and recreate.
What are the uses of a database trigger?
How to use "in out" parameter properly?
Is a rollback possible to any savepoint?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Calculate difference between 2 date / times in oracle sql?
Oracle General 
