Hi, I would love to answer you with this question , hope you
will like an answer and a clear idea related to the same. So not
wasting much time lets get started.
3 areas of RDBMS runtime execution can be improved when
running SQL query are as follows
- Using of the column names on the place of * statement
while running the SELECT queries: This is one of the way
which can improve the runtime execution of the query as the query
need not to go through all the columns and search , instead of
which it already have the selected columns.
- Avoid re-using the code blindly : This refers
to the problem which may lead to the more time needed in the
runtime execution, this can be understood as if you copy a code
which fetches your data correctly then it must be edited
accordingly as it may be fetching more data than needed resulting
in the increase in the runtime execution.
- Do update and deletion process in smaller processes
: This can be understood in a way as if both the processes
are done in the smaller batches then the database can go online
quickly and resulting in the runtime execution imrovement.
Hope you got a clear idea related to the same .
Please like an
answer and do comment for any queries in the above
Thanks and Happy to help :)
HAPPY LEARNING