Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 12163 Views
- IBM, I also Faced
- E-Mail Answers
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
what are the prerequisites for costing transactions?
Tell me how to find the custom directory in front end?
List the types of flexfield?
Plz anybody send me Technical specification for AP Interface
Is soa a part of oracle fusion middleware?
What is a flexfield? List out its types.
Can u give the Documentation of Custom.pll in oracle apps
How to move the one file from one instance to another instance? And your scripts also?
tell me the scenarios of the independent in reports
q)what are the validations in sql*loader
Can we create tables in apps schema?
In oracle application how do you debug or trace errors?
do you know is it possible to run the interface without using oracle apps?
how can i print random rows in plsql table
Can you differentiate between mediator and osb?
