answersLogoWhite

0

Why should you set field sizes?

Updated: 12/22/2022
User Avatar

Wiki User

14y ago

Best Answer

Efficiency in design is very important to a database.

Properly set field types and sizes are critical in the scalability and performance of a database.

As an example a varchar default is a field size of 50 characters. Now if you have a State field that will always contain two characters then a default size of 50 characters would be a big inefficiency. The actual data size stored is slightly padded and the efficiency of your indexes would be degraded as well.

Another consideration is field types. Using a varchar where numeric data is stored is probably one of the biggest mistakes made as far as field definitions are concerned.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why should you set field sizes?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is 'A database uses characteristics such as field size and data type to define each field' false?

No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.


How big is a soccer field for age 12?

Field sizes must conform to the sizes set out below: Age Group 11-12 Min Width 42 meters Max Width 55 meters Min Length 60 meters Max Length 75 meters


How do you write Field of study?

There are not set limits on how you should write a field of study. You can write this field of study in any way that you'd like.


How do you see the field size and or caption for a field in Access?

Go to Design View for the table. Click on the particular field. Then look at the properties of the field and you will see the size and caption. Some data types have fixed sizes, like dates and times, while others you can set yourself, like Text.


How big ia a U12 soccer field?

There is no unified standard for youth field sizes.


What sizes are the Milano 11-Piece Bedding Set available in ?

The Milano 11-Piece Bedding Set is available in King and Queen sizes.


What sizes of screwdrivers are included in a standard screwdriver set?

Many sizes of screwdrivers are included in a standard screwdriver set. The sizes range from half an inch up to two inches. One can buy individual screwdrivers as well.


Is set of integers is a field?

The set of integers is not closed under multiplication and so is not a field.


What numbers on the tires need to stay the same when you buy new tires for the same rims and which numbers can you buy in different sizes?

The set of numbers in the middle, and the set of numbers at the end should remain the same, the first set of numbers can be change.


Is the field irrational numbers complete?

This set cannot be answered since the set of irrational numbers is not a field!


How many players are on the field for track and field?

There is no set number. Some track meets have a limit to the number of entries but I have never heard of any team having a set number of people. the only reason a college team may have a limit is if a coach sets one.


What are the size of the squares on a chessboard?

The sizes of the squares can vary with the size of the set.