Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 36106 Views
- CarrizalSoft Technologies, Infosys, Oracle, I also Faced
- E-Mail Answers
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 tuple in sql?
Why schema is used in sql?
What is exception? What are the types of exceptions?
How do I view a sql trace file?
How to run sql statements with oracle sql developer?
what is commit? : Sql dba
What is cost in sql execution plan?
How do you clear the screen in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
How do I write a cron which will run a sql query and mail the results to agroup?
What are the methods of filing?
How to take user input in pl sql?
How many scalar data types are supported in pl/sql?
What is database white box testing and black box testing?
What is nosql example?
