X-Received: by 10.55.72.141 with SMTP id v135mr2275829qka.24.1513071398934;
        Tue, 12 Dec 2017 01:36:38 -0800 (PST)
X-Received: by 10.31.159.211 with SMTP id i202mr335352vke.3.1513071398747;
 Tue, 12 Dec 2017 01:36:38 -0800 (PST)
Path: news.netfront.net!goblin2!goblin.stu.neva.ru!peer01.am4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!m31no3417923qtf.0!news-out.google.com!t48ni2535qtc.1!nntp.google.com!m31no3417919qtf.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Tue, 12 Dec 2017 01:36:38 -0800 (PST)
In-Reply-To: <p0ljtn$jfe$1@dont-email.me>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=221.124.49.20;
 posting-account=Pa322QkAAABhYOAATVjsQFrxmnUViR5F
NNTP-Posting-Host: 221.124.49.20
References: <bf9f7aa2-6493-49d7-bbc3-7451bad20d30@googlegroups.com> <p0ljtn$jfe$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4cece44d-0edc-461e-a6ee-8f940e882bbc@googlegroups.com>
Subject: Re: Introduce an innovative machine tuning tool for SQL statements
From: tracyto41@gmail.com
Injection-Date: Tue, 12 Dec 2017 09:36:38 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Body-CRC: 660175688
X-Received-Bytes: 2485
Xref: news.netfront.net comp.databases.oracle.server:3790

On Monday, December 11, 2017 at 5:42:24 PM UTC+8, Noons wrote:
> On 11/12/2017 4:10 @wiz, tracyto41@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?  :)))

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.