Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?

Answer Posted / guest

This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

material view and view disadvantages?

1017


master table and child table performances and comparisons in Oracle ?

2068


What is the oracle implicit cursor?

998


Is there any function in oracle similar like group_concat of mysql?

986


20. Using a set operator, display the client number of all clients who have never placed an order.

2145


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2200


What is a snapshot log?

949


What is analyze command used for?

1009


What is the difference between Delete, Truncate and Drop in Oracle?

1065


What are the limitations of check constraint?

963


State the various uses of dbcc command?

989


What are the ways tablespaces can be managed and how do they differ?

2270


What is oracle datasource?

925


When do I need to use a semicolon vs a slash in oracle sql?

1026


How to import one table back from a dump file?

969