[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Check for redundant indexes

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> Dan Foreman's book says "B" is for single-component indexes. > Do we know the meaning of C, M, and N? "B": single-component index with a non-character field (including "default" index). "C": multi-component index where all fields are not character ones. "N": single-component index with character index field. "M": multi-component index with at least one character index field. "W": Word index (_Index._Wordidx = 1) IOW, it's 2x2 matrix + one special case (word index): (single- or multi-component) x (use a collation table or "native" sort weights)

Continue reading...
 
Status
Not open for further replies.
Back
Top