Path: news.netfront.net!goblin1!goblin.stu.neva.ru!eternal-september.org!feeder.eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Noons <wizofoz2k@yahoo.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: Introduce an innovative machine tuning tool for SQL statements
Date: Tue, 12 Dec 2017 20:45:54 +1100
Organization: NOYB
Lines: 17
Message-ID: <p0o8gn$nv3$1@dont-email.me>
References: <bf9f7aa2-6493-49d7-bbc3-7451bad20d30@googlegroups.com>
 <p0ljtn$jfe$1@dont-email.me>
 <4cece44d-0edc-461e-a6ee-8f940e882bbc@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 12 Dec 2017 09:46:00 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="8502095fa3e6ed3f2c27827f475886ec";
 logging-data="24547"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18gD2lTsBfLY/+HTpXQMbfk"
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.3.0
In-Reply-To: <4cece44d-0edc-461e-a6ee-8f940e882bbc@googlegroups.com>
Content-Language: en-US
Cancel-Lock: sha1:GFgjyXBAf/8YhxARNR6kG1rVG3o=
Xref: news.netfront.net comp.databases.oracle.server:3791

On 12/12/2017 8:36 @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.
>>
> 
> 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?