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
- 4740 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 |
Where are the settings stored for each instance in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain oracle 12c new features for developers?
How to create a new user account in oracle?
How to view the tablespaces in the current database?
After update how do u know how many records got updated
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
6. Display the client name and order date for all orders using the traditional method.
what are different types of deletes?
What are the different pseudo commands? Explain in general?
What is a View ?
what is the difference between dbms and rdbms?
Oracle General 
