Skip to main content

How to minimize number of projections on a table?

  • February 12, 2014
  • 1 reply
  • 4 views

Mrao
Forum|alt.badge.img+1
  • Participating Frequently
Are there any techniques/best practices to minimize the number of projections on a table?

Sorting the columns from low to high cardinality in the TABLE DEFINITION can help minimize number of projection on a table?

1 reply

colin_loghin
Forum|alt.badge.img+2
  • Participating Frequently
  • February 12, 2014
I would use database designer in order to quickly get optimized projections. You could manually override them later on if needed.