#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2012
    Posts
    1
    Rep Power
    0

    Normalization and Query Performance


    Hello Guys,
    Basically I am doin a basic course in Database Design Management System in my BS I have read about normalization but had a problem in it. I want U guys to help me I need some technical specification regarding this topic.

    My Query is:
    "Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. but as it removes anomalies form data it effect query performance and why does this happen???"

    Take care
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,031
    Rep Power
    4210
    Originally Posted by Rizz84
    ...but as it removes anomalies form data it effect query performance
    this is nonsense

    who told you this?
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo