Re: Database Tuning Question

Seems strange.

The only explination i can give is that on the weekend, a dataload may have been going on and an index or two disabled to allow the dataload to go faster. The index which was disabled is used in your code hence runs slower on the weekend. The disabled index is then re-enabled later on in the weekend.

Total stab in the dark but you never know. ;-)

M

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!