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