Tips & Tricks

Tosska SQL Tuning Expert (TSE™) for Oracle®

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

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 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

 

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

No posts found.