CODEWITHSUNDEEP
sql-server
Karthik
Karthik

Reputation: 1

Select Query Running slowly for a particular table

In my table, I have more than 300 records in a table.

If, for example, I run 

select top 200 * from tablename

it runs fast. But if I run

select top 301 * from tablename

It's executing for a long time.....

Also, I can't run the following query at all:

select * from tablename

...it is too slow...

I want to the delete the records after 301 in that table.

Upvotes: 0

Views: 302

Answers (1)

DForck42
DForck42

Reputation: 20387

How wide is your table? What's the table definition look like?

If you have an identity column you could just run this:

delete from dbo.Table where TableID>301

Upvotes: 1

Related Questions