@hnasr : You can't understand your SQL query performance by looking at the SQL code. You need the execution plan. Take the SQL : select id from student where grade >= 99 It doesn’t tell you how fast it will run. If there isn’t an index on the grade column, it will do a full table scan • TwiCopy

Hussein Nasser

@hnasr

+ Follow

Backend and Database Courses courses.husseinnasser.com YouTube youtube.com/@hnasr Author of pglocks.org Engineer @esri

ID: 170687510

linkhttps://node.win calendar_today25-07-2010 13:52:00

21,21K Tweet

76,76K Followers

648 Following

Hussein Nasser

@hnasr

4 months ago

You can't understand your SQL query performance by looking at the SQL code. You need the execution plan. Take the SQL : select id from student where grade >= 99 It doesn’t tell you how fast it will run. If there isn’t an index on the grade column, it will do a full table scan

thumb_up_off_alt692

chat_bubble_outline14

repeat63

shareShare