I had two tables A & B having one common key.I created some indexes.Even thou performance not improved.I created views also,even after that performance not all improved.The query is as below.
SELECT a.customer_id , a.customer_code custCode
FROM A a ,B b
WHERE ROWNUM < 1000
AND a.Country_code = 'US'
AND UPPER(b.first_name) LIKE (:QueryStrFN)
AND (a.is_master = 'Y' OR a.is_master IS NULL)
AND b.customer_id = a.customer_id
ORDER BY custCode
Give me any suggestions/tips for the above query tuning.