| count of records [message #371303] |
Sat, 30 September 2000 09:08  |
Mandarapu Srinivas
Messages: 6
Registered: September 2000
|
Junior Member |
|
|
i have 10 lack records in a table to get the count
of records from that table
with "select * from table_name"
it is taking much time, how can i get in less time
please reply me
regards
srinu
|
|
|
|
| Re: count of records [message #371306 is a reply to message #371303] |
Sat, 30 September 2000 14:36  |
Naseer
Messages: 5
Registered: September 2000
|
Junior Member |
|
|
Hello,
why r u using 'Select *' for just counting rows?
well, better use count(*) or count(1) e.g.
select count(*) from abc;
or
select count(1) from abc;
it is recommended to use count(1) if
u just want to count.
greetings
naseer
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
