Re: Introduce an innovative machine tuning tool for SQL statements

On Monday, December 11, 2017 at 5:42:24 PM UTC+8, Noons wrote:
> 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? :)))

[Quoted] [Quoted] there are more than 100 hints from Oracle, if you pick 3 out from the 100 hints, the permutations is up to 1 million. No brute force can do it in your database. Received on Tue Dec 12 2017 - 10:36:38 CET