Every Customer/ User always wants a fast response on their data retrieval process. So we need to design a good database that provides best performance during data manipulation which results into the best performance of an application. However, there is no straightforward way to define the best performance but we can choose multiple ways to improving SQL query performance, which falls under various categories like creation of Indexes, usage of joins, and rewrite a subquery to use JOIN, etc.
As a developer, we know any SQL query can be written in multiple ways but we should follow best practices/ techniques to achieve better query performance. I’m highlighting some of them below:
Diwali is a festival of lights and one of the major festivals celebrated by Hindus, Jains and Sikhs. The festival usually lasts five days and is celebrated during the Hindu lunisolar month Kartika (between mid-October and mid-November). One of the most popular festivals of Hinduism, Diwali symbolizes the spiritual “victory of light over darkness, good over evil, and knowledge over ignorance”The festival is widely associated with Lakshmi, goddess of prosperity, with many other regional traditions connecting the holiday to Sita and Rama, Vishnu, Krishna, Yama, Yami, Durga, Kali, Hanuman, Ganesha, Kubera, Dhanvantari, or Vishvakarman. Furthermore, it is, in some regions, a celebration of the day Lord Rama returned to his kingdom Ayodhya with his wife Sita and his brother Lakshmana after defeating Ravana in Lanka and serving 14 years of exile.