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
- 4696 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 concatenate two text values in oracle?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
8. Display the client name and order date for all orders using the natural join keywords.
Differnce between view and index
What is tns name?
Can you have more than one content canvas view attached with a window ?
What is data block in Oracle?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Give the constructs of a package, function or a procedure.
Is there a function to split a string in plsql?
Oracle General 
