Re: Introduce an innovative machine tuning tool for SQL statements
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 12 Dec 2017 20:45:54 +1100
Message-ID: <p0o8gn$nv3$1_at_dont-email.me>
>
> 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.
>
Date: Tue, 12 Dec 2017 20:45:54 +1100
Message-ID: <p0o8gn$nv3$1_at_dont-email.me>
On 12/12/2017 8:36 _at_wiz, tracyto41_at_gmail.com wrote:
>> [Quoted] >>> 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. >>
>
> 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.
>
Precisely. So why advertise that Tosska crap as a product that can do it? Unless of course this:
"in which the engine tries every possible Oracle Hints combinations for a SQL statement to improve the execution speed"
doesn't now mean a brute force approach? Received on Tue Dec 12 2017 - 10:45:54 CET