Re: Introduce an innovative machine tuning tool for SQL statements
Date: Mon, 11 Dec 2017 20:42:11 +1100
Message-ID: <p0ljtn$jfe$1_at_dont-email.me>
On 11/12/2017 4:10 _at_wiz, tracyto41_at_gmail.com 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