SQL Server Performance

Vertical Partitioning

Discussion in 'Performance Tuning for DBAs' started by snehsoni, Jan 4, 2007.

  1. snehsoni New Member

    if i break up the table in two tables(Vertical partitioning) and create a view. if one table is having the most commonly used field and i query from the view then the view would use both the table by join or would fetch data from one table only?
  2. mmarovic Active Member

    It will join tables.

Share This Page