what happens if you drop all other indices and create one on
type, status, inuse (in that order). what does the plan look like then?

>From: "C Fraser" <Colin.Fraser@...>

>We are running a simple query against a table which is taking to long to
>execute... Details are as follows:

_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile