Top Best Tips to Improve SQL Query Performance

Do not use * in select Statment

[{"selector":"#anim-fce78249-2da1-4816-a208-48ba46cf18e4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ddad7bd2-d195-4f2c-be8e-df8d76455d58","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4ddc01b8-ce7d-43ad-a536-0c12e4b5e7d1","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-a02489d8-58ac-4e3c-adc9-e8053c532e2a","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Use Exists instead of Sub Query

[{"selector":"#anim-e8cf0f85-d165-4e4e-a51a-3b56872908c6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1ab2d455-4a01-448c-b141-6bc0f99b8d2e","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2eaf9f98-edef-4c23-8a6b-ebace33676f3","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-1390a1f6-0863-4971-afb7-9da73581baf8","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Use Proper join instead of subqueries

[{"selector":"#anim-60cefe46-08ed-449a-8739-86b9de7a7f6b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ad7354a1-0db7-42df-9803-7b7c8c624812","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0bc0ef37-764e-4df2-8b4b-a758f69b808e","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-8427ada4-1b5d-4141-9668-23381c311ef9","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Use “Where” instead of “Having” a clause

[{"selector":"#anim-e2f72c03-64c5-45fd-ba21-e83d3f97af39","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-70a7f6c7-ce89-446f-ad3f-586cd8bd1e8d","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-217d9c9d-0b74-48a6-b9c2-b5fdc2a349e5","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-b8576a71-ffde-4f7b-8e9c-bb35b868101d","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Apply index on necessary columns

[{"selector":"#anim-4aec3773-6106-42f4-a57f-f32f3f502d4d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-289271e1-a090-4ea4-8bf3-a19580c0ff85","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a13c28c3-1191-43d0-b658-2c20e33ede69","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-3f69862a-545b-4adf-906e-9e96fec1657e","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

For user-defined stored procedures avoid prefixes like “sp_”

[{"selector":"#anim-a4c3820e-e95c-455a-abb3-275693626ff6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3e16d92f-bf2a-4c71-887f-3d1b6c2fdd99","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ee82f874-985c-447b-b884-3d49acbc5e6b","keyframes":{"transform":["translate3d(-113.53846%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-35fbdb72-d178-4a6c-8d9a-769501d35e65","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Apply UNION ALL instead of UNION if possible

[{"selector":"#anim-4faf66bc-4962-4017-95c6-ce157d5804b4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4d3ca177-b9e6-4639-b118-0adf37e014bd","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3bf2a160-8f9f-461d-81f1-c432131e764f","keyframes":{"transform":["translate3d(-115.63519%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-e74e0378-6dda-4000-b830-2aefd6c75b9e","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Avoid query in a loop

[{"selector":"#anim-c2affdf3-a29f-427c-8a42-1c637a3900b1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-96697781-d2dd-4e1b-94d4-f208862e3647","keyframes":{"transform":["translate3d(0px, 125.20803%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e0d0044e-8bf5-4228-805b-f4b6d268e004","keyframes":{"transform":["translate3d(-117.26385%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-8ffb0027-c37e-4005-85de-02664a38c1f2","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]