Re: Index Updates

Graeme Slogrove ( (no email) )
Mon, 23 Mar 1998 10:06:43 +0200

On 20 Mar 98 at 10:22, Dale E. Reed Jr. wrote:

> here and it fairly quick. The bottom line is adding more memory to
> your SQL Server (and letting SQL Server access it) to get the query
> times down. If you are sorting the results, use a tempdb in ram of
> about 32 mb and it should really make a difference as well (but
> don't run out of memory, or SQL Server won't start!).

Absolutely ! When I was doing the online time pages, I found the
query time decreased by about 200% by simply adding the right indexes
to the table.


---Graeme Slogrove, BSc (Eng) Elec (Wits)FastLight Data Distribution cchttp://www.fdd.netTel: +27-(0)11-706-0212   Fax: +27-(0)11-706-0812