#DateForumTypeThreadPost
202 Feb 2014 @ 03:11 PSTDatabaseReplyStatistics Creation on Tables and Stat Subsets to Enable Faster Join QueriesI would disagree that DIAGNOSTIC HELPSTATS is the "best" way because that will simply identify all stats variations that are pertinent to the query you are studying and not necessarily gi...
122 Nov 2012 @ 08:17 PSTDatabaseReplyprimary index hash valueHashRow will not give you the "row uniqueness" portion of the row-id.  The SQL that Qaisar posted merely counts the rows currently in the table for a given row hash value and does no...