Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle.server    |    Oracle Sysadmins question their careers    |    44,300 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 43,073 of 44,300    |
|    Ed Prochak to trac...@gmail.com    |
|    Re: Introduce an innovative machine tuni    |
|    14 Dec 17 11:49:43    |
      From: edprochak@gmail.com              On Tuesday, December 12, 2017 at 4:53:18 AM UTC-5, trac...@gmail.com wrote:       > On Tuesday, December 12, 2017 at 5:46:08 PM UTC+8, Noons wrote:       > > On 12/12/2017 8:36 @wiz, tracyto41@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.       Somehow it is better than an experienced DBA?              I'm not seeing the benefit.        Ed              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca