Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help appreciated.
SELECT B.Name,P.Products_Name
FROM
Brands B, --Has 125671
Products P -- Has 4894382 ( Huge records)
WHERE
B.Brand_ID >= P.ACCT_ID
AND B.Brand_ID <= P.SLD_ID