Database optimization is an important part of running any query, it helps the database select the most optimial way of accessing the data wanted by the user, though research in this field gives good accuracy, its still lacking in terms of real world results.