Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Table & Application Performance

    Hi Experts,


    I have a database containing more than 150 tables and most tables have more than 100 column .What are the impact that going to happen? I fear that will affect the performance. What i need to do?

    Can i go for normalization Or 100 or 150 columns is ok for a table?

    TIA

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What you need to do most is to make sure that you have the "correct" indexes on each table.


    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •