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.

Which certification is best for sql?

981

---

What is microsoft t sql?

936

---

What are different types of keys?

1094

---

Why do we use view in sql?

941

---

Explain exception handling in pl/sql?

1029

---

Is pl sql still used?

968

---

how can we know the number of days between two given dates using mysql? : Sql dba

1039

---

how to drop an existing index in mysql? : Sql dba

1059

---

How does rowid help in running a query faster?

1409

---

What is time based sql injection?

952

---

Which are the different case manipulation functions in sql?

1014

---

Is sql a microsoft product?

942

---

What does a pl/sql package consist of?

971

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

970

---

what is blob? : Sql dba

1138

---