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
- 4016 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 commands are there in sql?
What are literals in sql server?
Why do we need pl sql?
I need a function for a train ticket reservation please answer it thanks in advance
How do you rename a table in sql?
What will you get by the cursor attribute sql%notfound?
How to handle bulk data?
How we can update the view?
Is like operator in sql case sensitive?
How does postgresql compare to mysql?
What is triggering circuit?
How much does sql certification cost?
What is spool?
Whis is not false in primary key?
can sql servers linked to other servers like oracle? : Sql dba
