Difference between selective and non-selective SQL query
Below are the difference of Selective and Non-Selective SQL Query. A query is Selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows. And the performance of the SQL query improves when two or more filters used in the WHERE clause meet the … Read more