Here are initial tips for writing efficient/ cost-effective Queries When using AND, put the condition least likely to be true first. The database system evaluates conditions from left to right, su…