SQL Excution Plan or Path

[BravoTwoZero]

Hi,

I am not sure if the quary belongs to this forum but can anybody kindly explain to me, what is 'SQL Excution path' or what do your understand regading 'SQL Excution path'?

Many Thanks

Bravo

[plumsauce]

If you are referring to MS/SQL the execution plan
is the work plan that the sql optimiser has
decided as being the best sequence of steps and
combination of indexes for performing the desired
task. (in a nutshell)

For further information see the BOL.

The concepts should be similar under DB2, Oracle, RDB.

+++++