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;

What is nvarchar max in sql?

0 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

What is the use of partition by in sql?

0 Answers  

---

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

what is a trigger? : Sql dba

0 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

Is primary key clustered index?

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---