Good morning all,

I am looking for lists of guidelines or tips for writing efficient sql queries to help to increase application performance and query tunning, and the reasons of using them. These tips including using NOT EXISTS instead of NOT IN and never use NOT on an indexed column etc. If you have the lists, can you share with me? You can send them to Or can you send me a link where I can find them?