Could someone provide me advice on what is the best way to design a growing database.
Should I create Index on every table.
And what is your advice on some of the best practice and standard to go by ? For example after I design it and create it, how does an expert know or not know if someone good or expert has design it. What would be the tell tale signs and how do I avoid those pitfalls ? Please advise !