+ Reply to Thread
Results 1 to 3 of 3

Thread: Density

  1. #1
    Deon Hynes
    Join Date
    Jan 2011
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default Density

    Hi All,

    I can't found any info on the density column that is stored in the sde.st_geometry_index table. I know what the description is, but what I am looking for is recommendations on the value that is stored. Ex: if I have a feature class with a density of 237 is that good or bad? If it is bad how do I change or alter this value.

    Thanks
    Deon

  2. #2
    Vince Angelo

    Join Date
    Feb 2010
    Posts
    2,720
    Points
    755
    Answers Provided
    108


    0

    Default Re: Density

    As with most tuning situations, a single scalar value is unlikely to be good or bad on its own.
    What is more important is the context -- How many total features? How many index rows
    per feature? How large is the usual query? How large is the expected return result for the
    usual query?

    I don't think that table was really meant to be a human resource. You might try using the
    'sdelayer -o si_stats' utility, which will give more information about the nature of your
    spatial index parameters, and their context with respect to the whole. If you post the
    results here, we might be able to help you more.

    - V

  3. #3
    Deon Hynes
    Join Date
    Jan 2011
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default Re: Density

    thanks vangelo

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts