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
- 12267 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
Tell me how to debug the report?
In sequence i want to 11 and 15th values how we will write?
In support project one ticket alloted which steps follows manualy tell me ?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How can you achieve loose coupling in soa framework?
What is instead of trigger in where we will use?
Can u give the Documentation of Custom.pll in oracle apps
what is global tempory table?
Can you differentiate between mediator and osb?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
What do you understand by concurrent programs?
please send me forms, xml pulisher questions,answers
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What is sca and how is it useful?
