any orderby is over-head (small or big). Also limit with order by is not cost-efficient since limiting is done after ordering rows, resulting in fetching of all rows.
For time being, I am using executesql to execute my query.
any orderby is over-head (small or big). Also limit with order by is not cost-efficient since limiting is done after ordering rows, resulting in fetching of all rows.
For time being, I am using executesql to execute my query.