Database optomization

Very often this is about indexing columns, or if a table is too big, should consider splitting the database and tables horizontally or vertically. Also, SQL should be well-written.