How to add indexed columns to improve SPQuery performance


  • Hi,

    My document library contains 5000+ items, so I plan to use indexed columns to improve SPQuery performance.

    What I want to know it which columns should be indexed column.

    Generally, it is said that I have better choose the columns used in <where> clause as indexed columns.

    But in my SPQuery.Query, here is no <where> clauses used. Only SPQuery.Folder, ViewAttribute, ViewField are set. ( target folder, "Scope='Recursive'", "<FieldRef Name='target field' />" respectively)

    Hope someone helps me.


    2012年6月28日 1:57