Execution Plan

I saw the word ORDERED FORWARD In Execution Plan. What it means?.
Regards
It means that SQL Server uses an index to find the rows, and dictates that the engine need to follow
the index in order and not use the IAM page or similar to get to the rows. You 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.googlegro ups.com...
>I saw the word ORDERED FORWARD In Execution Plan. What it means?.
> Regards
>