Tosska SQL Tuning Expert (TSE™) for Oracle®
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 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 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
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
Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®
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
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
Tosska In-Memory Maestro (TIM™) for Oracle®
No posts found.