Clustered Index

Question

Post reply

Clustered Index

Viewing 15 posts - 31 through 44 (of 44 total)

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

sequelgarrett SSC Eights! Points: 836 More actions · Answer 1

Nevertheless, I understood the concept you were trying to convey.

The programmer inside of me had to point out a very specific detail. 😉

I thought that was a very good question by the way, it shows understanding of how clustered indexes 'work'.

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Nice question, no ambiguities. Really good explanation - I very much liked that you took the trouble to mention that TRUNCATE TABLE works even when the clustered index is disabled. Congratulations on providing the best question and explanation I've seen for quite some time.

Two tiny niggles (which just go to show that one can find something to complain about even in the finest question): (i) query 1 is two statements, not one. If you call all statements "queries", it's two queries; if you call only DML statements queries it's zero queries, so there's really no way it can be one query.

(ii) query 5 is two statements, and as both are dml statements most people would call them two queries - although perhaps it's reasonable not to count insert as a query.

Tom

demonfox SSCertifiable Points: 6289 More actions · Answer 3

L' Eomot Inversé (3/5/2013)
Nice question, no ambiguities. Really good explanation - I very much liked that you took the trouble to mention that TRUNCATE TABLE works even when the clustered index is disabled. Congratulations on providing the best question and explanation I've seen for quite some time.
Two tiny niggles (which just go to show that one can find something to complain about even in the finest question): (i) query 1 is two statements, not one. If you call all statements "queries", it's two queries; if you call only DML statements queries it's zero queries, so there's really no way it can be one query.
(ii) query 5 is two statements, and as both are dml statements most people would call them two queries - although perhaps it's reasonable not to count insert as a query.

thanks for pointing that out .. I think, word "statement" (and,may be, a batch separator "Go") could have been a better dessert..:-)

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: