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;

Why do we use joins in sql?

0 Answers  

---

What is a delimiter in sas?

0 Answers  

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

What is rename command in sql?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

What is the purpose of design view?

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---