sanonward001
Last Activity: Aug 14 '08, 10:06 AM
Joined: Aug 12 '08
Location:
-
Thanks All for your co- operation and quick response . It works :) -
Query Tuning for a single select statement
Hi,
This is regarding the query optimization.
T_A table is having rows around 570000, and this query's cost comes out to 202.
SELECT COUNT(1)
FROM T_A
WHERE LOWER(NAME) = LOWER(V_CIName)
AND TYPE_ID = V_CIType_Id
Is there any other way of writing the query to reduce the cost of this.
I am in fix as the cost of such small...
No activity results to display
Leave a comment: