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 ?
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 |
Explain the relationship among Database, Tablespace and Data file?
am completed mca2011 how get certification in oracle
how to join query for one source type is oracle another source type is sql server ?
What are the various types of snapshots ?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
From the database level, how can you tell under which time zone a database is operating?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is a nvl function?
The join defined by the default data link is an outer join yes or no ?
How to insert a record into a table?
Describe the different type of Integrity Constraints supported by ORACLE ?