Unix/Linux Go Back    


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

Sybase ASE - Query Tuning - Need Suggestion

Programming


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 05-17-2017   -   Original Discussion by Perlbaby
Perlbaby's Unix or Linux Image
Perlbaby Perlbaby is offline
Registered User
 
Join Date: Oct 2011
Last Activity: 27 December 2017, 6:32 AM EST
Posts: 62
Thanks: 9
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
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux 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 08:23 PM
Sybase ASE: Query to find correct format issue. Perlbaby Programming 2 04-25-2017 10:28 PM
Hierarchical Query for Sybase database Perlbaby Programming 6 06-27-2016 07:18 PM
Need help with complex SQL query (Sybase) chatieremerrill Programming 2 07-23-2008 04:07 AM



All times are GMT -4. The time now is 12:04 PM.