Jon Index - Compression & PPI


Jon Index - Compression & PPI

Just a qq on join Index as we are building them as part of the Performance.

can we have compression for JI ? and does JI supports PPI ?

waiting for the response


Re: Jon Index - Compression & PPI

There's no MVC available for JI. But there's another kind of compression available by grouping the columns in select statement.

ie like

(col1,col2) , (col3,col4,col5)

so the index is compressed on col1,col2 (called the fixed portion, the values for other columns will be repeated). See the data definition manual for exact syntax and the design manual for the applications :-)

PPI comes in with 6.2 but you can't have both together.