Saved Bookmarks
| 1. |
Explain The Function Of Optimizer In Oracle? |
|
Answer» The optimizer determines the most EFFICIENT way to execute a SQL statement based on the kind of DATA in the table and the STATEMENTS fired to fetch that data like INDEXES, full table scans, loops, joins etc. Optimizers are also used to avoid EXCESSIVE I/O resources. The optimizer determines the most efficient way to execute a SQL statement based on the kind of data in the table and the statements fired to fetch that data like indexes, full table scans, loops, joins etc. Optimizers are also used to avoid excessive I/O resources. |
|