Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4037 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
Write a sql query to find the names of employees that begin with ‘a’?
Differentiate between sga and pga.
Explain the purpose of %type and %rowtype data types with the example?
Can we use having without group by in sql?
Is sql better than excel?
What is the difference between rollback and rollback to statements?
How to place comments in pl/sql?
How do you determine the current isolation level? : Transact sql
What are the disadvantages of not performing database normalization?
What is the use of non clustered index?
Explain some predefined exceptions.
Is sql workbench free?
what is oracle database ? : Sql dba
What is the difference between microsoft access and sql?
how do you login to mysql using unix shell? : Sql dba
