# Table Analysis:

## Column Set Analysis

This analysis focuses on a column set (full records) and not on separate columns as it is the case with the "Column Analysis". The statistics presented in the analysis results are the row count, distinct count, unique count and duplicate count which all apply on records (values of a set of columns). With the Java engine, you may also apply patterns on each column and the analysis result will return the number of records that match all the patterns on the list.
Beware that this analysis will retrieve as many rows as the number of distinct rows in order to compute the statistics. Hence, it is advised to avoid selecting primary keys in this kind of analysis.