Home » RDBMS Server » Performance Tuning » How to calculate Selectivity and Skew
How to calculate Selectivity and Skew [message #65504] Fri, 08 October 2004 08:36 Go to next message
Messages: 16
Registered: September 2004
Junior Member
How can we calculate the selectivity of an Index and
data is skewed in table or non skewed
Thanx Gurinder
Re: How to calculate Selectivity and Skew [message #65507 is a reply to message #65504] Fri, 08 October 2004 22:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please have a look here.

with dbms_stats there are options to find the skewed columns
please have a look here
Previous Topic: Does compute statistics and Coalesce Tablespace Imporve Performance
Next Topic: Foreign keys with non-matching column definitions
Goto Forum:

Current Time: Tue Feb 27 07:37:17 CST 2024