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

Report message to a moderator

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.
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

Report message to a moderator

Previous Topic: Does compute statistics and Coalesce Tablespace Imporve Performance
Next Topic: Foreign keys with non-matching column definitions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 01:42:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.