Re: query plan

In <2thui0INN84u@phage.cshl.org> lombardi@cshl.org (Diane Lombardi in Beach Lab) writes: | I am trying to improve the performance of a particular | query. I am using Sybase sql server v4.9.2. | 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. Does the query optimizer | keep the query plan somewhere. Is there a way to | keep this plan perminantly so the optimizer doesn't | have to figure it out each time the application is | run? Sybase has a huge cache. The 2nd time your query is run, perhaps all the data are already in memory. Turn on the statistics on the physical and logical I/O. Another possiblility is that since your second query uses different values, it turns out to have a better query plan. -- Qing Vincent Yin | Repeat umyin@mctrf.mb.ca | delete(next_bug); | Until 0 = 1;