Re: Optimising queries

From: "Doug" <drmiller100@xxxxxxxxxxx>
Date: 24 Mar 2006 08:44:30 -0800

oh.
the overhead for indexes comes in teh creation (one time, not too bad),
inserts, and deletes and updates.

Not usually a HUGE issue unless you are doing huge transaction tables.

.

References:
- Optimising queries
  - From: Chris Weston
- Re: Optimising queries
  - From: Erland Sommarskog
- Re: Optimising queries
  - From: Chris Weston

Prev by Date: Re: Optimising queries
Next by Date: Accessing Oracle Tables From Within SQL Server 2000
Previous by thread: Re: Optimising queries
Next by thread: Website navigation hierarchy with SQL Server 2005
Index(es):
- Date
- Thread

Relevant Pages

Re: RCVJRNE/exitpgm vs. Mimix
... I don't think the MQ overhead should be anything to worry about (unless ... the OP is anticipating 100s of updates per second, or more, in which ...
(comp.sys.ibm.as400.misc)
Re: 10.5.5 Released!!
... Presumably the updates are compressed, ... of any 64-bit overhead. ... Leopard has 64-bit versions of the x86 UI libraries, ... system binaries are 32-bit. ...
(uk.comp.sys.mac)
Re: Defrag Doesnt Work
... No overhead, faster, and better ... diskeeper was always chasing NT updates. ...
(microsoft.public.windows.server.sbs)