Joining Tables: Table OrderWhat affects the join order?

• Number of rows in the tables

• Indexes available for:

  • Filters
  • Join Columns

• Data Distribution

• UPDATE STATISTICS on a regular basis

  • weekly or after large loads
  • update stats low on table drop distributions
  • updates stats high on leading columns of indexes
  • varies based on application

Previous slide

Next slide

Back to first slide

View graphic version