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
gurinder
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: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please have a look here.
http://www.akadia.com/services/ora_index_selectivity.html

with dbms_stats there are options to find the skewed columns
please have a look here
http://www.orafaq.com/articles/archives/000018.htm
Previous Topic: Does compute statistics and Coalesce Tablespace Imporve Performance
Next Topic: Foreign keys with non-matching column definitions
Goto Forum:
  


Current Time: Sun Sep 27 21:02:44 CDT 2020