what is count(*) from po_vendors(any table)? what does it do
and
what is count(1) from po_vendors(any table)?
what is count(0) from po_vendors(any table)
the out put is same
what is the difference
Answer Posted / sandeep sutar
Result if count(*), count(1), count(0) will be same.
Howevenr,
When we use count(*) then
first oracle query executer gets all the rows in buffure
cache, including all column and then counts all the rows.
this will impact with less performance.
select count(1) or count(0)
This reduces unwanted I/O by selecting just '1' against all
the rows.
Best practice to getting rowcount of table is
select count(rowid) from table_name;
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
List the various types of value set.
do you know is it possible to run the interface without using oracle apps?
What do you understand by soa?
q)what are the validations in sql*loader
What is sca and how is it useful?
what is the difference between request group and request security in oracle apps?
In sequence i want to 11 and 15th values how we will write?
List the types of flexfield?
can we use look up type instead of a pofile option?or valueset?is it possible how?
how can i print random rows in plsql table
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What does appl_top directory contain?
Plz anybody send me Technical specification for AP Interface
tell me the scenarios of the independent in reports
what is global tempory table?