Execution Plan

I saw the word ORDERED FORWARD In Execution Plan. What it means?.
RegardsIt means that SQL Server uses an index to find the rows, and dictates that t
he engine need to follow
the index in order and not use the IAM page or similar to get to the rows. Y
ou can see an ORDERED
FORWARD, for instance when an index is used to handle an ORDER BY in a query
, so that SQL Server
doesn't have to do a later SORT operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Praveen" <apveen@.gmail.com> wrote in message
news:1144242688.534865.95810@.u72g2000cwu.googlegroups.com...
>I saw the word ORDERED FORWARD In Execution Plan. What it means?.
> Regards
>