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 / 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 |
Explain lock escalation? : Transact sql
How do you create a unique index?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Is sqlite good enough for production?
What is the difference between python and sql?
What are the parts of a sql statement?
What is the purpose of cursors in pl/sql?
What is the difference between nvl function, ifnull function, and isnull function?
How can a pl sql block be executed?
who introduced sql?
Can there be 2 primary keys in a table?
How do I make my sql query run faster?