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 |
Can we call procedure inside function in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
what is the dual table in oracle?
What is archive log in Oracle?
Explain integrity constraints?
What are the differences between number and binary_float in oracle?
what is Table ?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
What is the sid in oracle?
How to connect to oracle using service name instead of sid?