Answer Posted / shail

Use function based index.
Ex: you have a date column and a simple index on it.
maximum queries referring to this column of this table
are like trunc(date_column). Then the index on this column
will be ignored. For this you can have function based index
like trunc(date_column) on this column.
This will speed up your sqls.

What is prepared statement in sql?

1004

---

What are the basic techniques of indexing?

1024

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

965

---

Can we use pl sql in mysql?

966

---

What is structural independence and why is it important?

982

---

What is clause in sql?

1063

---

Why we use stored procedure instead of query?

958

---

Is foreign key mandatory?

947

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1055

---

How to prepare for oracle pl sql certification?

1015

---

Is sql workbench free?

944

---

What is union?

1088

---

What is a function in oracle pl sql?

987

---

What is sql in oracle?

1010

---

How do I count duplicates in sql?

1038

---