Do you rely on the index Tuning Wizard from query analyzer to index your table?
Dan -----Original Message----- From: Showbear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 15:58 To: ActiveServerPages Subject: RE: Sql Server 2K Dan, one of our apps has a SQL Server 2000 database in which some tables contain over 25 million rows. Properly indexed, performance is - to be scientific - blink-of-an-eye fast. HTH -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:09 AM To: ActiveServerPages Subject: OT: Sql Server 2K Hi all, I have a fairly complex DB structure from which I query and return XML results. The structure is working fine, but the query can be a bit slow as I have to query several differnt tables (Well comparatively slow, running about 700-2000 ms). I have created a lookup table which is a single table with all the variables in it, the question is, this table is currently at 250,000 rows. I have re-wrote the query to use this yet, but is it better to do it this way rather than link across the 5 or so tables? The row count could easily get close to the 1million mark in the future. Dan _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
