Index Primer - Just what statistics are kept?
An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.
2009-10-28
7,776 reads
density
RE: unique values
quote: Oops, should have added the following: Open Query Analyser. Change database to your database. Copy and paste code from previous post. tnx it helped me a lot. another question. what if i have two tables, table1 & table2. table1 contain columns -- table1id [uniqueID], name [varchar] table2 contain columns -- table1id [uniqueid], number [int]. […]
2003-06-25
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers