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
- 4568 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 |
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How to view all columns in an existing table?
What are privileges and grants?
What is a server parameter file in oracle?
What is a SNAPSHOT ?
What is use of oracle?
What is the function of Optimizer ?
Why is oracle so popular?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
what is data independence exactly? give an example
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
What are virtual columns?
Oracle General 
