article on the optimiser generating a query plan

Is there a nice article on where i can find out how the query optimiser
chooses a query plan and what kind a plan it might choose with some examples
?
Whether it may use nested loop joins or merge or hash , whether it will do a
table scan, Clustered Index scan or seek.,etc...Take a look at:
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
and
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> Is there a nice article on where i can find out how the query optimiser
> chooses a query plan and what kind a plan it might choose with some
examples
> ?
> Whether it may use nested loop joins or merge or hash , whether it will do
a
> table scan, Clustered Index scan or seek.,etc...
>|||The 2 URLs are the same. Is that a generic place u sent me to about SQL
Server or is there a specific article out there
"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:uIj1A3FbDHA.2024@.TK2MSFTNGP12.phx.gbl...
> Take a look at:
>
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
> and
>
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
> --
> Hal Berenson, SQL Server MVP
> True Mountain Group LLC
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > Is there a nice article on where i can find out how the query optimiser
> > chooses a query plan and what kind a plan it might choose with some
> examples
> > ?
> > Whether it may use nested loop joins or merge or hash , whether it will
do
> a
> > table scan, Clustered Index scan or seek.,etc...
> >
> >
>|||Superb... I havent read it though but it looks like what i was looking for.
When is part 8 due ? Do you have all that clubbed together somehow for an
easy print ?
Good Luck to u
"joe chang" <jchang6@.yahoo.com> wrote in message
news:0e5d01c36cb4$6583dec0$a601280a@.phx.gbl...
> http://www.sql-server-
> performance.com/jc_sql_server_quantative_analysis1.asp
>
> >--Original Message--
> >Is there a nice article on where i can find out how the
> query optimiser
> >chooses a query plan and what kind a plan it might choose
> with some examples
> >?
> >Whether it may use nested loop joins or merge or hash ,
> whether it will do a
> >table scan, Clustered Index scan or seek.,etc...
> >
> >
> >.
> >|||Hassan,
MS SQL Server Performance Tuning and Optimization for Developers, Part 2:
The Query Optimizer
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> Is there a nice article on where i can find out how the query optimiser
> chooses a query plan and what kind a plan it might choose with some
examples
> ?
> Whether it may use nested loop joins or merge or hash , whether it will do
a
> table scan, Clustered Index scan or seek.,etc...
>|||Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> Hassan,
> MS SQL Server Performance Tuning and Optimization for Developers, Part 2:
> The Query Optimizer
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > Is there a nice article on where i can find out how the query optimiser
> > chooses a query plan and what kind a plan it might choose with some
> examples
> > ?
> > Whether it may use nested loop joins or merge or hash , whether it will
do
> a
> > table scan, Clustered Index scan or seek.,etc...
> >
> >
>|||Hassan,
Except some basic stuff, I dont believe it holds good for SQL2000
considering the presentation date and the author not explictly stating the
SQL Server version.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eKkSoMObDHA.1204@.TK2MSFTNGP12.phx.gbl...
> Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> > Hassan,
> >
> > MS SQL Server Performance Tuning and Optimization for Developers, Part
2:
> > The Query Optimizer
> >
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > > Is there a nice article on where i can find out how the query
optimiser
> > > chooses a query plan and what kind a plan it might choose with some
> > examples
> > > ?
> > > Whether it may use nested loop joins or merge or hash , whether it
will
> do
> > a
> > > table scan, Clustered Index scan or seek.,etc...
> > >
> > >
> >
> >
>|||This is a SQL Server 6.5 presentation and doesn't apply to SQL Server 7.0 or
2000.
The articles at
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/sql7qp.asp
and
http://msdn.microsoft.com/library/en-us/dnsql7/html/sqlquerproc.asp
were written for SQL Server 7.0 but are 90% accurate for SQL Server 2000 as
well.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eKkSoMObDHA.1204@.TK2MSFTNGP12.phx.gbl...
> Is that good enough for SQL 2000 ? It says Tech-Ed 97.. Can you confirm ?
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23gjaEuNbDHA.2820@.tk2msftngp13.phx.gbl...
> > Hassan,
> >
> > MS SQL Server Performance Tuning and Optimization for Developers, Part
2:
> > The Query Optimizer
> >
>
http://www.microsoft.com/technet/prodtechnol/sql/maintain/optimize/dat411.asp?frame=true
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:uX8$UyFbDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > > Is there a nice article on where i can find out how the query
optimiser
> > > chooses a query plan and what kind a plan it might choose with some
> > examples
> > > ?
> > > Whether it may use nested loop joins or merge or hash , whether it
will
> do
> > a
> > > table scan, Clustered Index scan or seek.,etc...
> > >
> > >
> >
> >
>