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;

how to start mysql server? : Sql dba

1141

---

How many sql core licenses do I need?

880

---

What is varchar data type in sql?

1009

---

Is sql the best database?

912

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

954

---

What is a table?

955

---

How do you modify a trigger?

874

---

What are the disadvantages of not performing database normalization?

1091

---

Which normal form is best?

895

---

What are character functions in sql?

891

---

What is t sql in sql server?

1000

---

Can one improve the performance of sql*loader? : aql loader

980

---

What is character functions?

1015

---

What are the different types of dbmss?

962

---

explain the difference between myisam static and myisam dynamic. : Sql dba

884

---