Re: Delete from takes a very, very long time

From: Joe (J_no_spam_at__no_spam_Fishinbrain.com)
Date: 02/16/05 

Date: Tue, 15 Feb 2005 20:40:10 -0500

CONSTRAINT [PK_research] PRIMARY KEY CLUSTERED

This is from the create script.

Could it matter that I added 5 - 7 million records in one section and
removed them in another 10-12 times?

"pdxJaxon" <GregoryAJackson@Hotmail.com> wrote in message
news:OJbA#d8EFHA.3672@TK2MSFTNGP14.phx.gbl...
> I dont think this table has a clustered index on it
>
> the Scan Density doesnt make sense
>
>
> GAJ
>
>

Relevant Pages

  • Re: sql script
    ... You need to drop the PK constraint, drop the existing index, create the new ... clustered index then create the PK constraint. ... > i need to write a script so that i can just execute it on the server. ... > do this using the GUI that SQL SErver 2000 provides. ...
    (microsoft.public.sqlserver.programming)
  • Re: More index questions
    ... EVERY TABLE should have a clustered index defined. ... fkey (security), two floats, a type, a date and a varchar notes ... Data is unique on fkey, ... One last question about the compound constraint. ...
    (microsoft.public.sqlserver.server)
  • Re: [PHP] Passing vars w/refresh w/register globals off?
    ... Dont know why you want to, ... This wasy all you need is pass the ID within the browser. ... > switch for routing to desired pages according to form input data. ... I'm thinking the old script would be php3 and the new ...
    (php.general)
  • Re: Looking for maybe impossible script?
    ... The admin rights on the laptops were ... Even if i could get a script that would notify me of such ... I just dont have the time. ... aide fix and tracing them down to the port an then shuting it off. ...
    (microsoft.public.windows.server.scripting)
  • Re: cannot script ONLY indexes
    ... I have Wrote a vry good utility to script the Indexes. ... Primary key non clustered index ... DECLARE @tableId INT ... UPDATE #indexInfo SET ...
    (microsoft.public.sqlserver.connect)