Re: USEOSTIME and performance

>I have been asked to check the performance differences between USEOSTIME >on and off. I expected the that there would be a slightly better >performance (4-5% according to manual) with USEOSTIME = 0/No. This >isn't the case on the tests done, in fact it is exactly the reverse. >With USEOSTIME set to 1/Yes it is consistently better by 4-5%. > >The test script is a simple insert into a temp table, no time >information used. > >Anybody care to comment, or spot something I've missed > If the table does not make use of any "time" column, then the impact of USEOSTIME would not come into effect. The difference in the time would be due to some other factor, possibably some key pages already in the bufferpool. Madison Pruet