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
- 4675 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 |
7. Repeat query (7) but also display all clients who have never ordered anything.
Whether any commands are used for months calculation? If so, what are they?
Will you be able to store pictures in the database?explain.
why can't we assign not null constraint as table level constraint
What is the difference between "as" and "is" in an oracle stored procedure?
26. Display the earliest shipping date in the format: DD/MON/YYYY
when do u go for hash partitioning?
How to run create database statement?
What are steps required to ENTER DATA INTO DWH?
How to write date and time interval literals in oracle?
How many types of auditing in Oracle?
What is the difference between SQL and SQL Server?
Oracle General 
