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
- 12096 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
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
can we get profile values in report without using user exists is it possible how?
how to print multi lay outs,muti currency,muti language in xml publisher
In oracle application how do you debug or trace errors?
What are do's and dont's of Interface?
Can u give the Documentation of Custom.pll in oracle apps
what is global tempory table?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
what are the different transaction clauses in AR?
where to define interorganization transaction charges and what are the different options?
What are the different components of soa suite?
is it possible to run the interface without using oracle apps?
What are the different components you should consider while defining a responsibility in oracle apps?
tell my any difficult situtation you solved in your experience in your company?
How can a process be deployed in soa?
