 Related Questions The goal of the optimizer is to choose the most efficient way to execute a SQL statement. Latest Answer : The optimizer determines the most efficient way to use the tables and indexes to complete the request made by an SQL statement after considering many factors related to the objects referenced and the conditions specified in the query. ... The combinations of the steps the optimizer chooses to execute a statement is called an execution plan. Latest Answer : The operations that the oracle server performs to execute a SQL statement. ... What are the different approaches used by Optimizer in choosing an execution plan ? Rule-based and Cost-based. The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints COST and RULE. Latest Answer : One can specify COST , RULE or CHOOSE for OPTIMIZER _MODE in init.ora file ... What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? CHOOSE,ALL_ROWS,FIRST_ROWS and RULE. What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How? by creating a function for sorting in the front end(guessing, i am not sure. plz answer it)
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
