Solve This (? + ? + ?=30)
If 1111=R, 2222=T, 3333=E, 4444=N Then 5555=?
Guess the Hindi Muhawara from the following whatsapp Emoticons?
Sweet, Medicine, Film, Girl, City, Car, Place, Doggy all are name same, guess which word it is?
A girl is blind, deaf, dumb and uneducated too. A boy loves her. How would he propose without touching her?
Four Question, One Answer: One River Name, One Flower Name, One Film Name, One Actress Name?
Guess me who am I, I am the first on earth, the second in heaven...
Which Indian cricketer is known as "Brown Bradman"?
The script for what movie was written during shooting breaks on the set of Raiders of the Lost Ark?
What is the maximum age to join Indian cricket team?
which of the following is better to find the number of rows in a table?
Please follow the link http://www.brentozar.com/archive/2014/02/count-number-rows-table-sql-server/
the answer is 1. and 3.
The function count() executes faster when given a criteria/value which is quicker to resolve in the sql processing mechanism.Thus, an integer or rowid are faster to resolve than an '*'which is a wild card symbol for all the colums in a table and hence it is more time consuming.
Its a very basic question but it would be good if anyone can answer with some explanations. When we type select * from dba_users; in sql plus it will show N rows selected and total records whereas when we type select * from employee it would show only records but not the total count.
select * from dba_users;
select * from employee
Which of the following is not a schema object: Indexes, tables, public synonyms, triggers and packages?
Forgot Your Password?
2018 © Queryhome