Re: query plan

> I noticed that the first time I execute the query > the performance is a little slow. The second time > I execute the same query, with different search values, > the performance is terrific. More likely, your data is read physically the first time and the second time you get cache hits. Before executing the querry, try "set statistics io on" and look at the logical vs. physical reads for each invocation. Topher --- Christopher "Topher" White | "The problem with justice in this country McCaw Cellular Communications| is that there are too many hung juries Kirkland, Washington | and not enough hung defendants." <Standard disclaimers apply> | -- Dennis Miller