Tags » Skew

Skewed Data: Analyzing the Windows

Previously, we looked at analyzing a table to see which columns in that table may contain skewed data.

That was a good start, but now it’s time to look at the statistics that exist on that column to see if we can identify potential candidates for filtered statistics, based on the “windows” between histogram steps. 463 more words

Skewed Data: Finding The Columns

While in the process of looking for a job that led to the position that I currently hold, I interviewed for a job at a recognizably-named company that was struggling to keep up with their “statistics.” I have a confession. 1,236 more words

movies to look out for: PEELERS [2016]

After a strenuous 11 days without posting anything, I’m finally back to write. For good reason too, I received an email from a man who goes by the name of… 786 more words

Horror

Solution: Parallel Activity just drops

As you remember we had a hash join outer with dominant null values. Thus, the parallel process dealing with the null values got most of the work to do. 366 more words

Oracle

The Market Drops, the Vix Jumps and the SKEW...Drops?

While hell breaks loose in the markets…

the Vix unsurprisingly jumps…

but the CBOE (Chicago Board of Exchange) Skew index, that reflects the volatility of out-of-the-money options, quite unexpectedly drops… 254 more words

English

Parallel Activity just drops

In one of my DWH POCs for Oracle’s Real World Performance Group we did see an unexpected drop of activity. The customer wanted to know why it happened. 162 more words

Oracle

A Little Upcycle

A week later than planned, due to the car radiator letting go on the way home from work one evening. Bearing in mind my car is a grey import, and parts are sometimes difficult to get or expensive, I was very surprised. 439 more words

Woodturning