Frequently Asked Questions

General

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

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 * ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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™ ...
Read More

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 ...
Read More

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 ...
Read More

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™) ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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

Tosska SQL Tuning Expert (TSE™) provides the first 30 alternatives for free if you don’t have a license. If you ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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™) ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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 ...
Read More

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

We don’t recommend to use those functions at the same time on the same database, since they might interfering with ...
Read More
Yes, it is the purpose that IM Advisor is designed not only solve your existing performance problems with current inmemory ...
Read More
Unless your production database are free to run IM Advisor for a period of time, we don't recommend user to ...
Read More
Yes, it is still worth it to tune your SQL with IM SQL Tuning even all the tables are already ...
Read More
It all depends on how much physical memory you have, if your system memory configuration is tight, you should consider ...
Read More
Before installing Tosska In-Memory Maestro (TIM™) for Oracle®, please make sure your system meets the following minimum hardware and software ...
Read More
Please note the following limitations when using this trial: IM SQL Tuning Auto Scenario can generate at most 10 auto ...
Read More
If you know when the bottleneck of your system is, you can use AWR to retrieve SQL workload from the ...
Read More
If you have one or more than one of the following questions in mind with the new Oracle® In-memory features, ...
Read More