How do you optimize SQL queries ?
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.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of disabling a trigger?
Can we group by two columns in sql?
Name three sql operations that perform a sort.
What is a stored procedure in sql with example?
What are database links used for?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is sql indexing?
Can we join same table in sql?
What are the triggers associated with image items?
What does select top 1 do in sql?
How exception handling is done in advance pl/sql?
Which are the different case manipulation functions in sql?
What is the life of an sql statement?
What is the difference between rename and alias?
What is a sql select statement?