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
- 3541 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
What are the different types of dbms?
Why do we use subquery?
What is before trigger?
what is offset-fetch filter in tsql? : Transact sql
Cite the differences between execution of triggers and stored procedures?
What is the command used to fetch first 5 characters of the string?
Does pl sql work in mysql?
Where the sql database files are stored?
What are the dml statements?
How many types of sql are there?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is sql scripting?
What is sql exception?
How do you use collections in procedure to return the resultset?
How to process query result in pl/sql?
