Order in Where Clause

Can anyone give a decent answer to how thigs should be ordered in a WHERE clause of a lrage multi-table select?

Ive heard it matters a great deal, to it doesnt matter at all...

I know that the FROM is very important, and simply chaing the order the tables are listed in cut a large query time in half...

Can optimizing the WHERE statement help anymore?

Ron

-- 
				     ,,,
				    (o o)
 +------------------------------oOO--(_)--OOo--------------------------------+


 |                                    |  It's a Mr. Death or something,      |


 | Ron A. Olshavsky - rono_at_netcom.com |  He's come about the reaping?        |


 |                                    |  I dont think we need any...  MP:MOL |


 +---------------------------------------------------------------------------+
            <My opinions are my own...Who else would want them...>