Performance tip while using COUNT function in Query
By Santhosh N
This explains how to use count function in sql query for better performance.
COUNT function in oracle get gets the number of rows in the query. We can improve the
performance of the query involving COUNT function by using COUNT(1) instead of
column list or * (which brings all the columns) in the COUNT function.
EX: SELECT COUNT(1) FROM emp where sal > 10000
Related FAQs
This explains how to find the arc sine value of the given number in oracle using mathematical function ASIN.
This explains how to find the median of the values in oracle using mathematical function, MEDIAN.
What is the real purpose of dual in oracle.
Listing all tables in Oracle depends on the user logged in and the schema one logs in
Performance tip while using COUNT function in Query (1332 Views)