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..



What is Function based Index and which type of function we can use in Function base index. can we u..

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

Post New Answer

More SQL PLSQL Interview Questions

What is memory optimized table?

0 Answers  


Why is %isopen always false for an implicit cursor?

0 Answers  


How to select all records from the table?

0 Answers  


Temporary table vs Table variable in sql server?

0 Answers   Wipro,


Is coalesce faster than isnull?

0 Answers  


What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  


There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,


How long it takes to learn pl sql?

0 Answers  


What is sql performance tuning?

0 Answers  


Mention what are different methods to trace the pl/sql code?

0 Answers  


What are %type and %rowtype for?

0 Answers  


What is a dirty read sql?

0 Answers  


Categories