How to measure that how many calculation will be made in a SQL select
operation?
Assume that there is a user_profile table with 10000 records and half of
records is female user ( = 5000 female users ).
If I send a query " select age(birth) from user_profile where sex =
'female' "
how many times will age function be performed? 5000 or 10000 times ?
No comments:
Post a Comment