compdigit44
asked on
Learning Database Design and Data Types
I'm learning about database design and have the following question.
If you choose a data type that works but is far larger of a data type then what is actually, will the poor selection of data type negativily impact the performace of a data base and cause higher memory usage since data types and there values are stored in memory?
If you choose a data type that works but is far larger of a data type then what is actually, will the poor selection of data type negativily impact the performace of a data base and cause higher memory usage since data types and there values are stored in memory?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Does anyone have any additional thoughts on this.
ASKER
Is there software out there can will scan your DB servers do see if it meets best practices / normizaltion standards