Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-26 Thread Mladen Gogala
Ursa Major means "great bear". As there is a connection between bears and the nickname that I've had ever since my childhood (no, I'm not going to reveal it), my assumption is that I have, somehow, originated there. On 2003.07.27 00:24, Guido Konsolke wrote: Hi Mladen, Ursa Major? Have been there

Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-26 Thread Guido Konsolke
Hi Mladen, Ursa Major? Have been there some years ago. Beautiful landscape, but too much hairy animals ;-)) But it was just a stop-over on my way to the gamma quadrant with the USS Voyager where I met Seven of Nine. Nice memory 8-))) And about my origins: I have to confess: I was born on this pl

Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-26 Thread Mladen Gogala
Hopefully, your analogy will not result in someone's attempt to pour Castrol motor oil in their PC to make it run better. As for being from the outer space, my origins are at Ursa Major. On 2003.07.26 18:39, Jared Still wrote: But the vast majority of them treat their computers like cars. They kno

Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-26 Thread Jared Still
Yeah, well them kids are real good at the pointy clicky stuff, and a minority actually know how to do some real programming. But the vast majority of them treat their computers like cars. They know how to drive them, but are clueless about how they work. We're still from outer space. Jared

Re: "data is skewed" - what does it mean ?

2003-07-25 Thread orababy
Oh... Thank U Mark. got it now. ...now i can explain it to someone who doesn't know. Cheers. Mark Richard <[EMAIL PROTECTED]>: > It's not this simple... > Let's take your low cardinality example... Gender is a good example since > there are only two (common) genders - male and female. > A t

Re: "data is skewed" - what does it mean ?

2003-07-25 Thread Mark Richard
list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: Re: "data is s

Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-25 Thread Guido Konsolke
Come on, don't try to persuade me of you being old. I'm 42 like you and still feel the blood running through my veins. At least, sometimes ;-) I can remember the (not so) good old times when everyone thought we 'computer wizards' came from outer space. Nowadays almost every school kid has a bette

Re: "data is skewed" - what does it mean ?

2003-07-24 Thread orababy
Gogala, If cardinality is high, then data is evenly distributed. If cardinality is low, then data is not evenly distributed and hence skewed. Is my understanding correct...atleast to some extent ?! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [

Re: "data is skewed" - what does it mean ?

2003-07-24 Thread orababy
Gogala, so , if there is an index on a column like SEX , then it means data ( in that index ) is skewed. am i right ? for an index , if cardinality is low OR clustering_factor is high --> it means data is skewed. sorry if i sound stupid :-| Is "SKEW" used with respect to index or table or bot

Re: Antw: Re: "data is skewed" - what does it mean ?

2003-07-24 Thread Mladen Gogala
Well, there have been situations when CBO made me use obscene language by stubbornly refusing to use and index which was utilized when RBO was used. I believe that the vast majority of old and balding DBA geezers like me can make the same claims. Thus the name. On 2003.07.25 02:04, Guido Konsolke w

Antw: Re: "data is skewed" - what does it mean ?

2003-07-24 Thread Guido Konsolke
Hi Mladen, nice one. Never heard that. Still lol, Guido >>> [EMAIL PROTECTED] 25.07.2003 07.54 Uhr >>> (snipped) chapter about indexes, statistics and the Curses Based Optimizer, am I right) (snipped even more) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido

Re: "data is skewed" - what does it mean ?

2003-07-24 Thread Mladen Gogala
It's actually a substitute for another word which is not to be repeated on this list because of the presence of the ladies, much like "heck", "darn" or "frigging". It means that the data in the index (you found that word in the chapter about indexes, statistics and the Curses Based Optimizer, am

"data is skewed" - what does it mean ?

2003-07-24 Thread orababy
List, Came across "~data is skewed~" while reading the docs. what does it actually mean ? can someone explain this for a novice dba like me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538