Re: IIUG 2008 survey for new features
In a thread on the IIUG 2008 feature survey, DA Morgan said Oracle has no equivalent of the Informix command UPDATE STATISTICS HIGH. Superboer replied rudely and pointed to an older Oracle newsgroup thread. Morgan answered that the advice there was to generate a histogram, quick in Oracle. Obnoxio The Clown teased Morgan. Mostly an argument, no resolution.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Superboer wrote: > Hello Daniel, > > have you tryed update statistics high in obstacle... > ougrhhhh yikes what a piece of shit to figure out the syntax.. > > > Superboer. Tried it? It doesn't even exist. There is nothing that even remote resembles the syntax "update statistics high" anywhere in the product. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond)
Hey dumb ashole: read: http://groups.google.nl/group/comp.databases.oracle.server/browse_thread/thread/f7fb9338e9660a0f/69b79a23879fe4bb?lnk=gst&q=superboer#69b79a23879fe4bb you pretend that you know it all.... you know nothing. Superboer On 8 okt, 17:03, DA Morgan <damor...@psoug.org> wrote: > Superboer wrote: > > Hello Daniel, > > > have you tryed update statistics high in obstacle... > > ougrhhhh yikes what a piece of shit to figure out the syntax.. > > > Superboer. > > Tried it? It doesn't even exist. There is nothing that even > remote resembles the syntax "update statistics high" anywhere > in the product. > -- > Daniel A. Morgan > University of Washington > damor...@x.washington.edu (replace x with u to respond)
Superboer wrote: > Hey dumb ashole: > > read: > > http://groups.google.nl/group/comp.databases.oracle.server/browse_thread/thread/f7fb9338e9660a0f/69b79a23879fe4bb?lnk=gst&q=superboer#69b79a23879fe4bb > > you pretend that you know it all.... you know nothing. > > Superboer Reading is an acquired skill. Here's what the doc you referenced states: "i am looking at V9 and try to figure out the equivalent command in oracle of update statistics high for table mytable(mycolumn) in informix" Note that "update statistics high" is an Informix command. You were adivced to generate a histogram. Something that can be done in a fraction of a second. And you are complaining that this is slow? PS: If you are going to use an obscenity at least learn how to spell it. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond)
DA Morgan wrote: > > PS: If you are going to use an obscenity at least learn how to spell it. > For shame, Danny: picking on an E2Ler for their English. Very bad form. Luckily I'd never do something like that! :o$ -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com