rowlocks on tables which has indexes

pts.
Tags:
SQL Server
behaviour of rowlocks on tables which has index/primary key differs from tables which does not possess those constraints.. can anybody make out difference between them.. dbms: sql server 2000 regards manickam

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you really want to understand it (or just get a good grade on your homework), you’ll need to read up on indices, pages, and leaves. But, essentially, they behave differently because when there is an index that can act as a primary key, whether it’s designated as such or not, the server can use it to lock rows, instead of generating pseudo-keys for each row. The actual effect on performance depends on a number of factors including, but not limited to, the number of rows, the size of the rows, the datatypes involved, and the design of the index, which includes a whole slew of factors all by itself.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following