Welcome to
Sign in
|
Help
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
T-SQL
»
Re: Numar mare de LogicalReads
Re: Numar mare de LogicalReads
10-16-2009, 9:29 PM
sirrocco
Joined on 01-24-2008
db_datawriter
Re: Numar mare de LogicalReads
Reply
Quote
Read-urile erau din tabela din care stergeam.
Rezolvarea a fost sa schimb tipul index-ului de PK din clustered in non-clustered. Acum se sterge instant. Nu stiu exact care sunt dezavantajele.
Nu se facea select din tabela aia dupa PK.
Report abuse
View Complete Thread