What is rule base and cost base optimizer?
Answer Posted / chandra bhusan prasad
one is supported in 8i and another in 9i/10g
cost base optimizer display the cost attributes of query
and it is easier.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the different types of sql commands?
How do rank () and dense_rank () differ?
Is truncate ddl or dml?
How do I add a primary key to a table?
How to get list of all tables from a database?
What are the types of subqueries?
what is a cursor? : Sql dba
Does sql view stored data?
how to extract a unit value from a date and time? : Sql dba
Does a join table need a primary key?
What is the function that is used to transfer a pl/sql table log to a database table?
How can we make an if statement within a select statement?
what is an index? : Sql dba
Is inner join faster than left join?
which operator is used in query for pattern matching? : Sql dba