performance

Question

performance

sunandas

Old Hand

Points: 357
More actions
December 29, 2008 at 9:09 pm

#217028

Hi,
I want to delete records from a table which contains huge records.Is there any solution to delete it in less time.If I am using rowcount then also it takes a lot of time as billion records are present in that table.
Is there any way to this.
Regards.
Sunanda

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

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

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

How many rows do you need to delete, how many rows are you keeping?

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

sunandas Old Hand Points: 357 More actions · Answer 2

I want to cleanup the table.As per my application we need to cleanup the table when the database size is increased.

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

GilaMonster (12/29/2008)
How many rows do you need to delete, how many rows are you keeping?

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

Jack Corbett SSC Guru Points: 184393 More actions · Answer 4

sunandas (12/30/2008)
I want to cleanup the table.As per my application we need to cleanup the table when the database size is increased.

Does this mean you don't need any of the rows? If so truncate table will work. If not, please answer Gail's question?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

sunandas Old Hand Points: 357 More actions · Answer 5

Around 30000000 records are there in the table.I cant use TRUNCATE as its index will also removed(though I can recreate it again).

So any other option.

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

sunandas (12/30/2008)
Around 30000000 records are there in the table.

And you want to remove all of them?

I cant use TRUNCATE as its index will also removed(though I can recreate it again).

Truncate doesn't remove indexes.

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