Performanance Issue with DELETE SCAN

Question

Post reply

Performanance Issue with DELETE SCAN

John Paul-702936

SSCrazy

Points: 2182
More actions
November 27, 2009 at 9:51 am

#214188

IS there any way to replce the DELETE SCAN in execution plan ...

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Are there indexes on the table? Are the indexes on fields in your where clause?

CEWII

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 2

Thanks For Reply ...

I noticed that ... Not because of DELETE SCAN the Execution is SLOW ..I have some Different problem with Query ...

The Problem is like ..

Hi , I am trying to Delete a record for table using one Specific Column ..

It takes large amount of Execution time .. I noticed that because of the referenial Integrity .(Foriegn KEY )

Is there any way to DELETE a specific record in a Table and the Record in the Referenced tables .....

Very Very Thanks

Please HELP ME ..

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

The table can be modified to allow for cascading deletes which is discussed in BOL at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/54ca1d10-5106-4340-bde4-480b83e7e813.htm

Read carefully the reference in its entirety. As noted if 3 or more tables have CASECADE on DELETE set ,you could have serious, if not disastrous consequences.

The other alternative, which again could have unintended results (as noted above) is to delete the value in the referenced table first and then in your table.

Using either way - test, then test again, and again.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

I really must push AGAINST cascading deletes, it makes it way too easy to delete data that you really didn't mean to or even know would be deleted..

CEWII

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 5

Please .......Pleaseeeeee

Reply Please ........................

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

John Paul-702936 (11/27/2009)
Please .......Pleaseeeeee
Reply Please ........................

Bitbucket did. What about his reply (which did answer your question on deleting records in related tables) was not sufficient?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ron McCullough SSC Guru Points: 63877 More actions · Answer 7

John Paul-702936 (11/27/2009)
--------------------------------------------------------------------------------
Please .......Pleaseeeeee
Reply Please ........................
Bitbucket did. What about his reply (which did answer your question on deleting records in related tables) was not sufficient?
--------------------------------------------------------------------------------
Gail Shaw

My guess it the OP wants the actual alter table statment and/or the actual T-SQL .....

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]