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
- 4687 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 |
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain an extent?
Explain integrity constraint?
What is a user account in oracle?
What do database buffers contain?
what is the difference between functional dependecy and multilevel dependency?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is a Temporary Segment ?
structural difference between bitmap and btree index ?
what are the diffeenes between oracle 9i,oracle 10g
What is oracle host variable?
What is Read-Only Transaction ?
Oracle General 
