Programming

Post questions about C, C++, Java, SQL, and other programming languages here.

Sybase ASE - Query Tuning - Need Suggestion

👤 Login to reply

    #1  
Old 05-17-2017
Perlbaby Perlbaby is offline
Registered User
 
Join Date: Oct 2011
Last Activity: 6 June 2018, 4:00 AM EDT
Posts: 69
Thanks: 10
Thanked 0 Times in 0 Posts
Sybase ASE - Query Tuning - Need Suggestion

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.

Code:
 
 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

Sponsored Links
👤 Login to reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Sybase ASE Soundex Function Issue -Need Suggestion Perlbaby Programming 1 05-16-2017 07:23 PM
Sybase ASE: Query to find correct format issue. Perlbaby Programming 2 04-25-2017 09:28 PM
Hierarchical Query for Sybase database Perlbaby Programming 6 06-27-2016 06:18 PM
Need help with complex SQL query (Sybase) chatieremerrill Programming 2 07-23-2008 03:07 AM



All times are GMT -4. The time now is 08:54 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password





Not a Forum Member?
Forgot Password?