Hi,
Its basically used for preventing performance issue.Like we have multiple view tables for database view and you have written where clause as needed,It will give the result as per the order defined for that table to avoid ambiguity for execution.
Hope this will help you.
Please mark my answer as correct/helpful if it helps you to find the solution.
Thanks and Regards,
Apurva Malewadikar
