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
- 4569 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
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between translate and replace?
What is logical backup in oracle?
How do I know if oracle client is installed on windows?
What is transaction control statement and how many types of transaction control statement in Oracle?
How can you merge two tables in oracle?
What are the different types of record groups in oracle? Explain each of them
How to upsert (update or insert into a table)?
What are the differences between char and nchar in oracle?
What is the difference between PFILE and SPFILE in Oracle?
Does oracle partitioning improve performance?
Explain about achiever in sql?
What is format trigger?
How to get execution path reports on query statements?
Explain overloading. Can functions be overloaded?
