Optimizer Behavior

[stmontgo]

Can someone reference me to a link that describes how the optimizer behaves in SQL Server 2000? Specifically what does it consider when chosing it's execution plan, what elements would cause the optimizer to consider using an index or not etc.

Thanks

Steve

[rmiao]

Try search 'query optimizer' in Microsoft TechNet.