473,327 Members | 2,103 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

I'm dense on Density

Hi all,

I've been doing some work trying to tune indexes in a couple of fairly large
tables that are slow for us to query. I've already gotten some
great suggestions from this group and they're much appreciated. One thing I
did to try and gather objective stats is run "DBCC SHOW_STATISTICS".

The question I have is on interpreting the results, particularly when it
comes to "Density". I read the docs in Books Online and it tells me,
basically,
that a lower density means higher selectivity for an index, which is good.
The actual description is:

DENSITY - Selectivity of the first index column prefix (non-frequent).
What does "non-frequent" mean and why is it in brackets?

I'm also finding that the Average Key Length is 0 for every index?

And finally, the ALL DENSITY stat - it's described as:
"Selectivity of a set of index column prefixes (frequent)." What's
"(frequent)" mean?
It shows different density stats for different combinations of columns, some
of which aren't in the actual index....so, I'm assuming that it's kind of a
"what if" analysis,
to show you what the density would be if you included different groups of
columns in the index? For a rookie, it's also hard to know the relative
magnitude of the density stats (e.g. is a density of "8" literally 4 times
as bad as a density of "2" ?) Are 2 and 8 both good numbers for density? Is
50 a good number? How high can the number go - know what I mean?

Here's a sample - it's confusing, because the density numbers are all over
the map (or maybe not - dunno):

Statistics for INDEX 'XIKudfvalues_UDFGUID_ConGUIDValueGUID'.

Updated Rows Rows Sampled Steps Density
Average key length

-------------------- ----------- ------------ ----------- ------------------------
------------------------

Oct 14 2004 9:34PM 7963050 7957900 300 8.4528123E-4
0.0

(1 row(s) affected)

All density Columns

------------------------ --------------------------------------------------------------------------------------------------------------------------------

4.0000002E-3 UDFGUID

1.2364455E-5 UDFGUID, ConGUIDValueGUID

1.330032E-7 UDFGUID, ConGUIDValueGUID, ConGUID

(3 row(s) affected)



I don't know from this result if the index is a star performer or in need of
drastic medical attention..any help is very much appreciated !!

Steve


Jul 20 '05 #1
0 1259

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
5
by: j_mckitrick | last post by:
When I was reading the PEP for code, Guido suggests using blank lines 'sparingly.' Yet, in most of the 'professional' code(1) I've seen, there are often HUGE amounts of whitespace, extra blank...
3
by: max khesin | last post by:
There has been a long argument as to whether high link density is good for the users. Some say it is, as it contains more information, the others say it is confusing. There is statistical study...
11
by: hasadh | last post by:
Hi, is the assemly code for if..else and switch statements similar. I would like to know if switch also uses value comparison for each case internally or does it jump to the case directly at...
3
by: MLH | last post by:
Me!AddnlOwnrList.Width = 5.1875 Me.Repaint Have tried the above in the on got focus event code to make the listbox control wider when its being used. I tried it in the Enter and Exit event code...
109
by: jmcgill | last post by:
Hello. Is there a method for computing the number of digits, in a given numeric base, of N factorial, without actually computing the factorial? For example, 8! has 5 digits in base 10; 10! has...
3
by: arda | last post by:
does someone know that ANSI C has a power density function or not? if not how can i achieve to do it ? or is there anyplace that i can find some info about it
6
by: news.demon.co.uk | last post by:
Hi All, let me try to explain what I'm trying to accomplish - I really hope someone can help. I have a table (tblArticles) which has the following: vcrKeywords varchar(2000) txtBody ...
0
by: ric3031urbina | last post by:
systimax high density patch panel http://cracks.00bp.com F R E E
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.