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
- 4692 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 |
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
How much memory your 10g xe server is using?
Difference between varchar and varchar2 data types?
how to find count rows in table without count function?
What is backup in Oracle?
What do you mean by a tablespace?
What is memory advisor in Oracle?
why pl sql doesn't support retrieving multiple records
How many categories of data types?
How to use subqueries in the from clause in oracle?
Oracle General 
