Frequently Asked Questions

General

Welcome to the world of Tosska ! We are happy that you have decided to partner with us to let ...
Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska ...
You are welcome to submit your support requests / bug reports to us by sending emails to support@tosska.com or by ...
Some users may encounter the error "Submission rejected, token invalid" when trying to download software from our website. If you ...

Tosska SQL Tuning Expert (TSEM™) for MySQL®

Tosska SQL Tuning Expert (TSEM™) for MySQL® – System Requirements

Before installing Tosska SQL Tuning Expert (TSEM™) for MySQL®, please make sure your system meets the following minimum hardware and ...

Why I can only see the first 20 alternatives after tuning of my SQL?

Tosska SQL Tuning Expert product series provide the first 20 alternatives for free if you don’t have a license. If ...

Tosska SQL Tuning Expert (TSE™) for Oracle®

Can I replace the variables of a SQL with literals for SQL tuning?

No, due to the Oracle SQL optimizer will treat variables and hardcoded literals in different ways. For example; Select * ...

Can I tune the SELECT portion only for an INSERT statement?

No, the SELECT portion’s execution plan may be different when it is executed with the INSERT operation. We recommend to ...

Can I use TSE™ to tune and test run DML statements?

Yes, you can tune DML statement such as Insert, Update and Delete statements. All update data will be rollback after ...

Do I have to install Oracle Client to connect a database?

No, you can use “Basic Type” option in the Connection Mode when you are creating a connection in Connection Manager ...

Do I have to tune the SQL statement again to get the best SQL alternative’s text after I have purchased a license?

No, the best SQL alternative text will be displayed immediately after you input a valid license into TSE™ ...

Do I use elapsed time or response time as my SELECT statement tuning objective?

Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online ...

How can I speed up the tuning process for long runtime SQL?

Yes, if you have an expected runtime of your SQL statement, you can use it as the termination time to ...

How does TSE Pro™ different from TSE™ ?

Below are the Products Features Comparison between Tosska SQL Tuning Expert Pro (TSE Pro™) and Tosska SQL Tuning Expert (TSE™) ...

How many times should I test run each SQL alternative?

If your SQL’s runtime is short such as less than 10 seconds, the time of data cache from hard disc ...

I cannot find a better SQL in the current SQL alternatives, what should I do?

If you cannot find a SQL with satisfied performance in current SQL alternatives, you can increase the Intelligent Level to ...

There are some SQL alternatives generated by TSE™ with row count mismatched error during test run?

Yes, it is possible that some SQL alternatives generated by TSE™ may have row count mismatched error. The problem is ...

Tosska SQL Tuning Expert (TSE™) for Oracle® – System Requirements

Before installing Tosska SQL Tuning Expert (TSE™) for Oracle®, please make sure your system meets the following minimum hardware and ...

Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download Limitations

Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download version has the following Limitations: If you use TSE™ without a ...

What should I do if no better alternatives can be found for my SQL?

If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the ...

Why I can only see the first 20 alternatives after tuning of my SQL?

Tosska SQL Tuning Expert product series provide the first 20 alternatives for free if you don’t have a license. If ...

Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®

Can I tune the SELECT portion only for an INSERT statement?

No, the SELECT portion’s execution plan may be different when it is executed with the INSERT operation. We recommend to ...

Can I use SQL Plan Baselines instead of SQL Patches?

Yes, you can turn on SQL Plan Baselines in Deploy Plan page in Options window, but we recommend using SQL ...

Do I have to implement all indexes recommended by TSE Pro?

You can evaluate the efficiency of the recommended indexes to your SQL workload to select most effective indexes for your ...

Do I use elapsed time or response time as my SELECT statement tuning objective?

Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online ...

How does TSE Pro™ different from TSE™ ?

Below are the Products Features Comparison between Tosska SQL Tuning Expert Pro (TSE Pro™) and Tosska SQL Tuning Expert (TSE™) ...

How does TSE Pro™ work and what technology does it use?

Tosska SQL tuning uses our proprietary Auto-Hints-Injection technology to highly explore a given SQL statement’s potential execution plans that the ...

How TSE Pro™ helps save your effort to implement the SQL performance fix

Developers are used to tuning SQL statements by rewriting or applying hints to the SQL text to influence database SQL ...

How TSE Pro™ helps save your effort to tune a SQL ?

There have been already a lot of SQL tuning products in the market providing better query plan visualization, better statistics ...

Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® – System Requirements

Before installing Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®, please make sure your system meets the following minimum ...

Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Trial Version Limitations

Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Trial Version has the following Limitations: The TSE Pro™ trial version ...

What kind of SQL workload should I capture for index recommendation?

You should capture the most representative SQL workload that created performance problem in your system. For example, if there was ...

What should I do if no better alternatives can be found for my SQL?

If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the ...

What’s new in Tosska SQL Tuning Expert Pro for Oracle Version 2 ?

Bring the automatic SQL tuning technology to new heights With almost doubled the number of hints supported in version 2, ...

Why I can only see the first 20 alternatives after tuning of my SQL?

Tosska SQL Tuning Expert product series provide the first 20 alternatives for free if you don’t have a license. If ...

Tosska In-Memory Maestro (TIM™) for Oracle®

No posts found.