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 full join in sql?

937

---

What is the execution plan in sql?

972

---

What is difference between stored procedure and trigger?

1058

---

What is procedure and function in sql?

927

---

Can we call stored procedure in function?

903

---

What is the need of a partition key?

940

---

How to check if a column is nullable before setting to nullable?

1055

---

Explain mutating table error.

1130

---

What is difference between rank () row_number () and dense_rank () in sql?

1049

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

905

---

what is a field in a database ? : Sql dba

989

---

What is a sql statement?

900

---

What is the difference between a database and a relational database?

1035

---

Is mariadb a nosql database?

1004

---

How do you write a complex sql query?

1007

---