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
- 4670 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
Oracle
What is the usage of save points in oracle database?
How to use "in" parameter properly?
How does Oracle guarantee data integrity of data changes?
What is parameterized cursor in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
how to do daily transactions with out sql* loader control file regesterd in apps?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to rename an index in oracle?
How do I manually create a database in oracle?
how can we store any pdf file in oracle
What are the most common interview questions on ETL Testing for experience?
What are data pump export and import modes?
Is rowid unique in oracle?
