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
- 4697 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 call a stored function with parameters?
what is difference between sql plus and sql*plus? (not sql and sql plus).
various types of hints and their usage
What is memory advisor in Oracle?
What are the uses of a database trigger?
17. Display the order number and average item cost for each order.
what is the syntax of UPDATE command?
What is a sub query? What are its various types?
Is java required for oracle client?
How to pass a parameter to a cursor in oracle?
What is redo log?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Oracle General 
