What is rule base and cost base optimizer?
Answer Posted / chandra shekher
Rule based optimiser will optimise the query based on the
rules.
Cost based optimiser will optimise the query based on the
statistics available for the table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is integrity in sql?
What is the use of %rowtype?
Is it possible to sort a column using a column alias?
Is primary key always clustered index?
How do I debug a stored procedure?
What is the maximum rows in csv?
What is sql not null constraint?
Which constraints we can use while creating database in sql?
How do I run a query in pl sql developer?
What is set transaction?
What is oracle sql developer?
how to create a new table by selecting rows from another table in mysql? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is trigger explain with example?
What is null in pl/sql?