what to use Flat tables or left joins with the tablein views for non-mandetory fields?

• mohitjetley

  Newbie

  Points: 1

  More actions

  March 24, 2009 at 12:29 am

  #128827

  Hi,

  I am using Sql Server 2005, I am pulling out Extracts data by using Views Directly.

  so in Views which one is better approach to extract data::::

  1) By putting data in flat table and making INNER join with that table for mandetory fields.

  2) By using left join in view with tables for Non-mandetory fields.

  thanks in advance

  Mohit

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  March 24, 2009 at 11:10 am

  #965428

  Hi

  Sorry, but I don't understand your question. Do you have a DDL and some sample data?

  Greets

  Flo

• Johan Bijnens

  SSC Guru

  Points: 135554

  More actions

  March 24, 2009 at 11:27 am

  #965447

  Opting for the left join, would mean a vertical split of the data into a number of tables.

  As always ... it depends ... mainly on your performance goals, but as well as your DA needs.

  If you go for the multi table solution, make sure you have a FK relationship to the table with the mandatory columns.

  I have recently seen an article regarding ".. symantic design.." I cannot recall the URL, but I think it was on the MS website "HowTo for SQL2005"

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me