Re: Introduce an innovative machine tuning tool for SQL statements

[Quoted] On Tuesday, December 12, 2017 at 5:46:08 PM UTC+8, Noons wrote:
> 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?

Yes, you are right. It should be

"in which the engine tries every possible effective Oracle Hints combinations for ....." Received on Tue Dec 12 2017 - 10:53:10 CET