Monday, August 6, 2012

Performance of Sub-query vs Joins in SQL

In any kind of computer applications have to use any relational database management system to persist the records for feature use, many people have been involved how to retrieve much more record in a shortest possible time , In RDBMs have may tables they have single or composite primary key , this is call entity integrity , those table are inter-related with using foreign keys, it is call referential integrity, today my idea to present comparision of performace of Sub-query vs Joins , Sub-query and Joins are main two techniques to combine two or more table and retrieve selected field from each tables