Query Performance

I have 2 tables, Make and Model where Make is the master table and Model has
a reference of make table by Make_Id since there can be multiple models for a
single make. Now, i have 4 SQL's below and i want to know which SQL should
perform better.

select make.make_name, model.model_name
from make, model
where make.make_id = 1000
and make.make_id = model.make_id


select make.make_name, model.model_name
from make, model
where make.make_id = 1000
and model.make_id = make.make_id


select make.make_name, model.model_name
from make, model
where make.make_id = model.make_id
and make.make_id = 1000


select make.make_name, model.model_name
from make, model
where model.make_id = make.make_id
and make.make_id = 1000

Thanks,
Moin




.

Relevant Pages

  • Re: Query Performance
    ... Make and Model where Make is the master table and Model has ... >a reference of make table by Make_Id since there can be multiple models for a ... Hi Moin, ... The usual answer to "which of these queries performas better" is to test ...
    (microsoft.public.sqlserver.mseq)
  • Master page event
    ... I have button on master page. ... How can I reference the button clik event from content page? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Referencing Master Page from a Web Control
    ... I am trying to get reference to a Master page from a web user control. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Request.Form contents are renamed while using masterpage.
    ... No problem with controls in master page. ... can find an example of accessing the post data via the reference to the ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Reference required to assembly error
    ... As for the isolated error behavior(two Master ... page reference call can not coexists), ... Microsoft MSDN Online Support Lead ... Adding this second line produces the compilation error, ...
    (microsoft.public.dotnet.framework.aspnet)