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
- 4741 Views
- IBM, I also Faced
- E-Mail Answers
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
When do I need to use a semicolon vs a slash in oracle sql?
What is the difference between view and materialized view in Oracle?
How to define default values for formal parameters?
Why do we use bulk collect in oracle?
How to speed up webrick?
What is the oracle implicit cursor?
What is a sub query? What are its various types?
What is open database communication (odbc) in oracle?
What is a user role in oracle?
can u plz provide me oca sql dumps please i need them
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to use existing values in update statements using oracle?
What is meant by an index?
What is the use of aggregate functions in oracle?
What are the uses of synonyms?
