count(1) will give the count of the numbr of records in the table. count(

select count(1) from emp? what is the o/p?

Question Posted / munni

Answer Posted / munni

count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Tell me about Propagate functions in informatica

923

Repository user profiles

1767

What are the different components of powercenter?

1055

Explain sessions?

1071

Whats the difference between informatica powercenter server, repositoryserver and repository?

1178

Explain the informatica workflow?

1074

How identifying bottlenecks in various components of informatica and resolving them?

1136

which one is better performance wise joiner or look up

1095

Explain the types of lookup transformation?

1046

How can we improve session performance in aggregator transformation?

1118

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4111

what is unit testing?tell me proceedure

2224

How can we create index after completion of load process?

1125

Can we create a Integration service without a Repository service and vice versa?

1215

wf dont have integration severances how you can run?

1941