Re: Introduce an innovative machine tuning tool for SQL statements

[Quoted] On Tuesday, December 12, 2017 at 4:53:18 AM UTC-5, trac..._at_gmail.com wrote:
> 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:
> >
[]
> > > 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 ....."

So it uses some heuristic algorithms.
[Quoted] Somehow it is better than an experienced DBA?

[Quoted] I'm not seeing the benefit.

   Ed Received on Thu Dec 14 2017 - 20:49:43 CET