Oracle Apps Technical Question: Download Oracle Apps Technical PDF

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?

Tweet Share WhatsApp

Answer:

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;

Download Oracle Apps Technical PDF Read All 17 Oracle Apps Technical Questions
Previous QuestionNext Question
Do you know is it possible to run the interface without using oracle apps?Do you know where we can check the status of po?