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
- 3944 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 using in sql?
How many types of literals are available in pl sql?
how to get help information from the server? : Sql dba
What is multiple columns?
What is sql performance tuning?
explain the difference between bool, tinyint and bit. : Sql dba
How do I run a sql trace?
what is the difference between a local and a global temporary table? : Sql dba
Are pl sql variables case sensitive?
What is the need of merge statement?
what is the difference between blob and text? : Sql dba
How many times can we commit in a loop?
Can a foreign key be null?
What are local and global variables and their differences?
What are functions in sql?
