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?
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;
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;
| Previous Question | Next 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? |