General
Welcome to the world of Tosska ! We are happy that you have decided to partner with us to let ...
Read More
Read More
Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska ...
Read More
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
Read More
Some users may encounter the error "Submission rejected, token invalid" when trying to download software from our website. If you ...
Read More
Read More
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 ...
Read More
Read More
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 ...
Read More
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Read More
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 ...
Read More
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
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
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
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
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
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
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
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
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
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
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
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
Read More
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, ...
Read More
Read More
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 ...
Read More
Read More
Tosska In-Memory Maestro (TIM™) for Oracle®
No posts found.