Re: Introduce an innovative machine tuning tool for SQL statements

From: Noons <>
Date: Mon, 11 Dec 2017 20:42:11 +1100
Message-ID: <p0ljtn$jfe$>

On 11/12/2017 4:10 _at_wiz, wrote:

> The machine tuning for SQL statements is a proprietary technology invented by Tosska to mimic a human expert SQL tuning process, in which the engine tries every possible Oracle Hints combinations for a SQL statement to improve the execution speed.

No human expert uses a brute force approach. And if all it does is "mimic", then it is not a "proprietary technology", or is it? :)

> As the permutation of Oracle Hints combinations to a SQL statement is so huge, it is impossible for a human expert to accomplish it for complex SQL statements.

Er... Human experts would only select the most likely combinations rather than use a brute force approach?
But I don't want to brute force you into human expertise...

> Furthermore, it is also no way for a DBA or developer to guarantee that the best solution is found after a lot of trials and errors.

Bingo! See? :))) Received on Mon Dec 11 2017 - 10:42:11 CET

Original text of this message