DENSITY & SELECTIVITY

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 8, 2008 at 3:41 am

  #196727

  Hi all,

  What are the difference between the two.

  Also is a low densisty (1) good or bad?

  Also is a low selecttivity (0) good or bad?

  thanks

  Chris

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 8, 2008 at 11:21 am

  #855409

  Density is basically selectivity. High selectivity is good.

  In Books Online, there's a good article on the subject:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/49b1cde3-4a67-4775-a942-ae1e2f1053e5.htm

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon