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 difference between IN and Exists in Oracle?

Answer Posted / ram

exists improves the performance because it returns boolian
value where as 'in' is not...so exists simplyfies internal
calculations....

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size of your data warehousing?

2093


What is workflow manager?

1044


What does update strategy mean, and what are the different option of it?

1089


Where do we use mapping variables in informatica?

1063


What is an expression transformation?

1010


Mention few advantages of router transformation over filter transformation.

1023


What the difference is between a database, a data warehouse and a data mart?

1153


What does command task mean?

1141


r u done any partitions in ur project?

1827


How might one distinguish in the case of mapping is right or not without associating session?

1114


list out all the transformations which use cache?

1180


What are the conditions needed to improve the performance of informatica aggregator transformation?

1093


Define mapping and session?

1033


design of staging area?

2030


What are the types of data warehouses?

1525