=tg= Thomas Grohser
Toggle navigation
InsideSQL.org home
Contact
Log in
Tag: "index"
increasing the performance of count(*)
Posted on Jan 26, 2011 by
tgrohser
in
Useless for most people...
The fastest count(*) can be archived if you create a secondary index on top of a clustered index only containing the clustered key Carefull this is an index that will be used only here ...
more »
Tags:
count
,
index
,
performance optimize
4 comments »
Alle Blogs
=tg=
Andreas Wolter
Armin Neudert
Christoph Ingenhaag
Christoph Muthmann
Downloads
Falk Krahl
Fehlermeldungen
Frank Kalis
Holger Schmeling
InsideSQL.org Blogs
Klaus Oberdalhoff
Olaf Pietsch
Pressemitteilungen
Sascha Lorenz
tosc
Uwe Ricken
Weblinks
XML Feeds
RSS 2.0:
Posts
,
Comments
Atom:
Posts
,
Comments
RDF:
Posts
,
Comments
RSS 0.92:
Posts
,
Comments
What is RSS?