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
- 4681 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
What is flashback in Oracle?
What is the difference between a hot backup and a cold backup in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to define an anonymous procedure without variables?
Explain oracle’s server parameter file.
What is the Tune Query
How to convert csv to table in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain what are the different type of segments?
What is a snapshot in oracle database?
Explain the use of Merge statement in oracle 11g
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is oracle database client?
What is Virtual Private Database in Oracle?
How to define a data field as not null?
