Learn SQL Database Programming

Chapter 15

1. It helps to ensure your data is consistent, accurate, and in the right format.
2. You must ensure that you name things accurately, descriptively, and at the same time avoiding keywords that will add any kind of confusion to the naming. You must avoid adding spaces in the names, choose the right case, and stick to one convention. You should make sure that you use only permitted characters when naming a database object.
3. If the data type is too large, it takes up too much space on disk. If the data type is too small, then it doesn't fit your data.
4. There is no right number of indexes on a table or columns in your indexes. Generally speaking, too few or too many indexes can make the performance of your database worse. This is why it's ...