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
- 4030 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 is normalization? : Sql dba
Can we write ddl statements in functions?
What is a sql instance vs database?
What are the operators used in select statements?
Explain dml and ddl?
What is sql query optimization?
Explain some predefined exceptions.
Is pl sql still used?
What is where clause in sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is sql table?
How do you optimize a stored procedure in sql?
What is prepared statement in sql?
What is group function in sql?
What is the difference between function, procedure and package in pl/sql?
