Database query optimization entails indexing, which is critical. The question optimizer makes use of the indexes to choose the best execution method for a particular question depending on the expense of accessing the information and also the selectivity of the indexing columns. Rose on Kapampanga