Using function in the query will get the performance issue (increase the loading time)
lets take a table has got more than 1000 records
example:
SELECT * FROM EMP WHERE UPPER(NAME) = UPPER('ram') takes 15secs
whereas
SELECT * FROM EMP WHERE NAME = 'ram' takes less than a sec
Thursday, August 9, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment