curiouswebster
asked on
Is "Partitioning" a form of database "Normalization"?
Is "Partitioning" a form of database "Normalization"?
I see the value of both strategies. Is breaking a database schema into smaller tables, more query centric tables, a form of Normalization?
Curious.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Also, what specifically improves query speed in this example?
1) Employee table with 1 million records, with 25-columns
query selects
a) ID
b) Annual salary
c) Zip Code
2) Employee table partition with 1 million records, with 3-columns.
query selects all three:
a) ID
b) Annual salary
c) Zip Code
Why exactly is the second option faster? What columns did not get loaded?