SQL Optimizer for SAP ASE Forum - Toad for SAP Solutions - Toad World
Danny Torres
Follow / 1 Nov 2016 at 2:06pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

381 0 / Create an account to join the discussion.
Danny Torres
Follow / 7 Jun 2016 at 2:20pm / Toad for SAP Solutions

IGNORE - Test Community Forum entry for training/testing purposes...

Expand content
*********************** Test Community Forum entry for training/testing purposes. Please ignore. Where can one download the latest version of SQL Optimizer for SAP? Where can one find their license...

***********************

Test Community Forum entry for training/testing purposes.

Please ignore.

 

Where can one download the latest version of SQL Optimizer for SAP?

Where can one find their license keys to authorize the product?

Thanks

 

***********************

Unanswered 665 0 / Create an account to join the discussion.
TheoJ
Follow / 7 Mar 2008 at 9:08am / Toad for SAP Solutions
Latest post by on 18 Jun 2015 at 10:31am

What can I do to get more alteratnatives?

Expand content
I had optimized a SQL in the SQL Optimizer window, but I there is no better alternatives. Is there any settings I can change to give me some alternatives?
I had optimized a SQL in the SQL Optimizer window, but I there is no better alternatives. Is there any settings I can change to give me some alternatives?
3720 2 / Create an account to join the discussion.
overnier
Follow / 29 May 2015 at 3:43pm / Toad for SAP Solutions
Latest post by on 18 Jun 2015 at 10:26am

use of variable

Expand content
Hello all, Could you please say to me how i can declare variables into sql optimizer for sap ase Many thanks. Olivier

Hello all,

Could you please say to me how i can declare variables into sql optimizer for sap ase

Many thanks.

Olivier

1817 3 / Create an account to join the discussion.
nsivashankar_859
Follow / 15 Jun 2009 at 6:31pm / Toad for SAP Solutions
Latest post by on 1 Jun 2015 at 2:36am

P&T for Stored Procedures

Expand content
Hi, How we can use this tool to optimoze the stored procs. Especially procs using cursors. thanks! Message was edited by: nsivashankar_859
Hi,

How we can use this tool to optimoze the stored procs. Especially procs using cursors.

thanks!

Message was edited by: nsivashankar_859
3575 1 / Create an account to join the discussion.
Mohamed Gamal
Follow / 31 Jan 2012 at 11:07am / Toad for SAP Solutions
Latest post by on 12 Feb 2012 at 5:30pm

I Need To Show Data In Arabic Language ????

Expand content
Hi, When I Query any Data From Database I Found "؟؟؟؟؟؟" For " Arabic Language " I Need To Solve This Problem Thanks, Mohamed Gamal
Hi,
When I Query any Data From Database I Found "؟؟؟؟؟؟" For " Arabic Language "

I Need To Solve This Problem

Thanks,
Mohamed Gamal
7616 2 / Create an account to join the discussion.
vivek.shrivastava_531
Follow / 1 Feb 2012 at 12:14am / Toad for SAP Solutions
Latest post by on 3 Feb 2012 at 8:09pm

Modify Date in "View details" view

Expand content
Hi, We are in the process of playing with this tool to see if it fits our needs.The product so far looks like it fits the bill but no commitments yet. I have aquick question related to a feature. Currently...

Hi,

We are in the process of playing with this tool to see if it fits our needs.The product so far looks like it fits the bill but no commitments yet. I have aquick question related to a feature.

Currently in "View Details" view for procedure/triggers, i see thesethree columns are avaialble

Name
Owner
Creation Date

is it possible to customize this view and add more columns like "LastModify Date"?

So far we have found this information (Last Modify Date) very helpful for somescenarios. We are hoping that this product do support this feature.

Please do reply.

Thanks,
VivekS

3946 3 / Create an account to join the discussion.
iahawksfan
Follow / 13 Dec 2011 at 2:59am / Toad for SAP Solutions
Latest post by on 16 Dec 2011 at 6:17pm

Subquery in From Clause Using Query Builder

Expand content
When I try and add subquery in the From clause in Query Builder, TOAD freezes up when I try and add a field from the second table. Is this is known bug on version 2.6? Are there patches available to address...
When I try and add subquery in the From clause in Query Builder, TOAD freezes up when I try and add a field from the second table.  Is this is known bug on version 2.6?  Are there patches available to address? 
3920 1 / Create an account to join the discussion.
Wayne in AZ
Follow / 25 Apr 2011 at 8:28pm / Toad for SAP Solutions
Latest post by on 4 May 2011 at 9:10pm

Forum Search Broken

Expand content
Haven't been able to use the forum search feature. Tried and gave up early last week - haven't visited the forums for a while so don't know how long it's been broken. Tried again today...

Haven't been able to use the forum search feature.  Tried and gave up early last week - haven't visited the forums for a while so don't know how long it's been broken.  Tried again today and still get:

/export/hda3/5.0.4/local/conf/frontends/sybase/domain_filter (No such file or directory)

Wayne

3635 2 / Create an account to join the discussion.
Tina
Follow / 14 Mar 2008 at 7:34pm / Toad for SAP Solutions
Latest post by on 17 Mar 2008 at 8:15am

How do I find the best SQL?

Expand content
I have optimized a SQL and it has generated over 100 alternatives, how do I find the best SQL? Can I use the cost value to select the best SQL?
I have optimized a SQL and it has generated over 100 alternatives, how do I find the best SQL? Can I use the cost value to select the best SQL?
3700 1 / Create an account to join the discussion.
Tina
Follow / 10 Mar 2008 at 6:51pm / Toad for SAP Solutions
Latest post by on 10 Mar 2008 at 6:57pm

Upgrading to ASE 15.0.2

Expand content
Hi, I am planning to upgrade from ASE 12 to ASE 15. Is there anyway I can check the SQL performance and to find out if I can prevent a downgrade in performance.
Hi,

I am planning to upgrade from ASE 12 to ASE 15. Is there anyway I can check the SQL performance and to find out if I can prevent a downgrade in performance.
3894 1 / Create an account to join the discussion.