Answer / 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;

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

Define commit, rollback and savepoint?

0 Answers  

---

What is nvarchar max in sql?

0 Answers  

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---

What is difference between nchar and nvarchar?

0 Answers  

---

Do you understand the meaning of exception handling?

3 Answers  

---

Which nosql database is best?

0 Answers  

---

How many disk partitions should I have?

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

What is anonymous block in sql?

0 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---