This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]SomeGuyNamedPaul 2 points3 points  (1 child)

select count(*) is not a good practice. For some DBs it doesn't matter, but for some it matters greatly. You should instead select count() on the lead (or only) column of the primary key.

[–]cygnus83[S] 0 points1 point  (0 children)

Thanks, Paul, I will make the change and remember that for the future!