Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
10 / 106
For Query Optimization, what methods you can use?
Answer:
1. Cost based Optimization (Physical)
This is based on the cost of the query. The query can use different paths based on indexes, constraints, sorting methods etc.
Asked In ::

Ashma
21 Nov, 2019 8:53 PM
1. Cost based Optimization (Physical)
This is based on the cost of the query. The query can use different paths based on indexes, constraints, sorting methods etc.