Which will be faster out of queries with explicit INNER JOIN and implicit one?
January 29th, 2008 | by Shubhabrata |Implicit one will be faster.
-
Meta
Categories
Tag Cloud
Apache class class autoloading eregi_replace ereg_replace Exceptions https Implicit Inner Join join Load balancing MySQL object oop Perl PHP php.ini PHP 5 Session SOAP Implementation sqlite ssl xml
Recent Comments
- Santhosh fernando:The above queries will not giv
- Santhosh:The above queries will not giv
- Sumesh:http://www.phpnew.co.cc/
- brijmohan:Good interview question with a
- brijmohan:Good one question with answer
- Sumesh:Explain more about explicit &a
- Sumesh:Correct Query is : “SELECT
- parthiban:Hi "SELECT name FROM table_
- Ajay:Nice information and easy to r
- Pooran Jaiswal:This function is identical to
Recent Post
- Install Apache, MySQL, PHP and Perl in one shot using xampp.
- What is the difference between inner join and outer join?
- What is the query to get the number of “names” from a table that is occuring more than 10 times.
- Describe the lifecycle of object creation.
- How do you maintain session in a load balancing system?
- Which will be faster out of queries with explicit INNER JOIN and implicit one?
- What is the difference between ereg_replace and eregi_replace?
- Why PHP 5 Rocks
- Importance of Class autoloading
- How to differentiate isset and empty
2 Responses to “Which will be faster out of queries with explicit INNER JOIN and implicit one?”
By Pooran Jaiswal on Aug 22, 2008 | Reply
i believe explicit inner join will be faster since in that case mysql doesn’t find the type of join. otherwise it will fetch all the records from both the tables and display it to user.
By Sumesh on Sep 30, 2008 | Reply
Explain more about explicit & implicit INNER JOIN