15+ SQL optimisation interview questions & answers with scenarios

1) Select fields instead of using SELECT *. The “*” is used as a short hand to query all available data from a table. If a table has many fields and rows, this takes database resources by querying a lot…

Java developer & architect Q&As

Java developers Q&As