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;

How do I edit a trigger in sql developer?

0 Answers  

---

How do you remove duplicate records from a table?

0 Answers  

---

What is lookup table in sql?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---

How can we avoid duplicating records in a query?

0 Answers  

---

What is the need of merge statement?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---