>
which is the optimize way for writing one of these...
Welcome, Guest

by nik on Saturday, 19 February 2011
which is the optimize way for writing one of these 2 queries??


I am asking this  by curiosity. This could be the most stupid question or basic question. Forgive me if it is..

 Suppose I have a isThatA table contains id, class, school_id having 1000 records.

 there are 3 schools and 12 classes.

Which of these 2 queries would be faster(if there is a difference) 

Query 1: SELECT * FROM isThatA WHERE school=2 and class=5; 

Query 2: SELECT * FROM isThatA WHERE class=5 and school=2;

Note: I just changed the places of the 2 conditions in WHERE

Also probable number of records for condition WHERE school=2 is 333

and probable number of records for condition WHERE class=5 is 80. 



Blogger Image
My Blog Title

Product Engineering, software engineering company, Product Development, Product Migration, Product Re-engineering, Product Maintenance, Product Testing Commercial Application Development, Business Software development, commercial software for startups, Application Support and Maintenance, software testing Product Maintenance, Outsource product maintenance, product support and maintenance Product Migration, Product Re-engineering, product re-engineering services Product Research, Product Engineering, UI Prototyping Services Software Testing Services, Quality Assurance services, professional software testers, Load Testing, Functional Testing, Cross Platform, Browser Testing, Test Automation, Testing Tools, software quality analysis Functional Testing Services, software quality analysis, Software Testing Services, Application Testing Services, Functional Testing Types Automated Testing, Automated Testing Services, automation testing, test script development, Automation Test Tools, outsource automation testing Load Testing, Performance Testing Services, Load Testing Tools Offshore Software Development, Outsource software services, offshore outsourcing services, offshore software development services, IT outsourcing services, software quality assurance services, Offshore IT services, Custom Application Development Services, Offshore Product Engineering Benefits of IT Outsourcing, Offshore Software Development companies, offshore software development firms Outsource planning, IT outsourcing, IT development services, offshore IT companies, offshore software development Offshore Software Development, Outsource software services, offshore outsourcing services, offshore software development services, IT outsourcing services, software quality assurance services, Offshore IT services, Custom Application Development Services, Offshore Product Engineering Offshore Software Development, Outsource software services, offshore outsourcing services, offshore software development services, IT outsourcing services, software quality assurance services, Offshore IT services, Custom Application Development Services, Offshore Product Engineering