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..
- 1 Answers
- 3215 Views
- Metric Stream, Polaris, I also Faced
- E-Mail Answers
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
How many joins in sql?
What is a variable in sql?
How are sql commands classified?
What is a record in pl/sql?
what is the difference between primary key and unique key? : Sql dba
Can I call a procedure inside a function?
How can you fetch first 5 characters of the string?
How to rename a table?
What are pl/sql packages?
How do I truncate a sql log file?
What is cursor explain with example?
How can I speed up sql query?
how to enter characters as hex numbers? : Sql dba
How can I change database name in sql?
How do I install sql?
