Correlated columns & firsts

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Correlated columns & firsts

Josh Berkus-6
Folks,

I had the impression that our new multicolumn stats feature was a first
in the industry.  However, a PDXPUG member said that SQL Server has
something like it for the last couple versions.

Anyone know if it's the same thing or not?

--
Josh Berkus
Containers & Databases Oh My!


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Correlated columns & firsts

Peter Geoghegan-4
On Wed, Jul 26, 2017 at 10:32 AM, Josh Berkus <[hidden email]> wrote:
> I had the impression that our new multicolumn stats feature was a first
> in the industry.  However, a PDXPUG member said that SQL Server has
> something like it for the last couple versions.

So does Oracle.

> Anyone know if it's the same thing or not?

I'm pretty sure that it is.

--
Peter Geoghegan


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Correlated columns & firsts

Alvaro Herrera-9
In reply to this post by Josh Berkus-6
Josh Berkus wrote:
> Folks,
>
> I had the impression that our new multicolumn stats feature was a first
> in the industry.  However, a PDXPUG member said that SQL Server has
> something like it for the last couple versions.
>
> Anyone know if it's the same thing or not?

A quick search led me to
https://dba.stackexchange.com/questions/84747/statistics-are-multicolumn-histograms-possible
which contains a pointer to
https://blogs.msdn.microsoft.com/ianjo/2005/11/10/create-multi-column-statistics/

then you can see the MS docs at
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-statistics-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/statistics/statistics

From what I can tell, they only store the correlation between the
columns, so it's simpler than what we do.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Correlated columns & firsts

Daniel Westermann (DWE)
>A quick search led me to
>https://dba.stackexchange.com/questions/84747/statistics-are-multicolumn-histograms-possible
>which contains a pointer to
>https://blogs.msdn.microsoft.com/ianjo/2005/11/10/create-multi-column-statistics/
>
>then you can see the MS docs at
>https://docs.microsoft.com/en-us/sql/t-sql/statements/create-statistics-transact-sql
>https://docs.microsoft.com/en-us/sql/relational-databases/statistics/statistics

For Oracle:
https://blogs.oracle.com/optimizer/extended-statistics