What is Function based Index and which type of function we can use in Function base index.
can we use aggregate,NVL function in Function based Index..
Answer Posted / dinesh
Its not batter to modify where clause column with function(Performance issue). So we need to create function based index. Eg.
Create Index Fun_indx on EMP (UPPER(FIRST_NAME).
we can't create function based index on aggregate function.
but we can create NVL function as function.
also we can create function based index on user define function but function should be"DETERMINISTIC".
eg
create or replace function fun_index(a in number) Return
Number DETERMINISTIC IS
BEGIN
'''
,,,
END;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a recursive stored procedure?
Which is faster subquery or join?
Is left join same as inner join?
What is a join?
Is join an inner join?
What is benefit of creating memory optimized table?
Does group by remove duplicates?
How to find 3rd highest salary of an employee from the employee table in sql?
How to download oracle sql developer?
How do I partition in sql?
How does left join work in sql?
What is sql constant?
What is the clause we need to add in function body to return variable?
does sql support programming? : Sql dba
Differentiate between % rowtype and type record.