You are viewing limited content. For full access, please sign in.

Question

Question

how much % of the database is indexed in LF SQL database?

Updated July 10, 2015
asked on July 9, 2015

I'm not a DBA but we have a client that asked this question. I asked what this question is for, the DBA answered saying this is for creating a plan to optimize SQL.

 

Any thoughts of the answer and as to what effects (performance wise) this is to Laserfiche? Thanks! 

0 0

Replies

replied on July 10, 2015

You can run `sp_spaceused` to get MSSQL to tell you data size vs index size, or you can inspect the schema if you want to know about the numbers of indexes vs columns or tables.  But if the asker is a DBA he should know about both of these, so maybe he means something else?

0 0
replied on July 10, 2015

Thanks for the giving your thoughts on this, i have a couple of follow up questions:

 

1. Is there a safe number (%) in data size vs index size that will have an impact in SQL performance?

 

2. Will there be a difference in performance if the number of indexes is greater than columns or tables?

0 0
replied on July 10, 2015

I'm not a DBA either, but as far as I am aware neither of those properties have much predictive power about performance beyond the impact that indexes always have.  I was just trying to offer guesses about what kind of data might answer the question and how how you might get the values.  Presumably the person asking the question would be able to interpret the data that you provide.

But again, I am having trouble interpreting the question in a way that they couldn't answer themselves with a SQL management tool, so I don't really know what they are after or how specifically they intend to use the answer.  I don't think I can be more helpful without additional clarification.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...