warehouse partitions and execution plans

Author: asktom.oracle.com | Published: 12th Aug 2007 | Visited: 89 times | Add Comment
Filed in: Oracle FAQ

hi tom in oracle we have two types of histograms height based and width based. why we have two types of histrograms? do these two histograms effect execution plan. because histograms represents data skewness. does data skewness in both the histogr...

Read Article

Sponsored Links

• Partitioning tables with unequal partitions. Hi Tom, We have data coming into our application from different entities/agencies and being loaded into several different tables. Each transmission contains data that belongs to a unique entity. We can also receive a new transmission for each ent ...

• sql tuning using execution plan Hi Tom, My Client complaints me that this particular query taking lots of time. initially it was working well. i tried to tune from my side but in vain i need a expert advice on this. please tom help me out in tuning this query. i will be very th ...

• ImageMagick Command Line Execution in ASP.NET Perform ImageMagick operations in ASP.NET using command ...

• Article :: Using Questions to Design Software Test Plans Good questions can help you develop ideas and build stronger test pla ...

• Microsoft AJAX Library - JavaScript Execution Context JavaScript Execution Context In this section we'll take a peek under the hood of the JavaScript closures and the mechanisms that allow us to create classes, objects, and object members in JavaScript. For most cases, understanding these mechanisms isn't absolutely necessary for writing Java ...

• Type-Strong Asynchronous Execution Executing a method asynchronously with typed parame ...

• NParallel, A Small Parallel Execution Library A Simple Library which allows you to write asynchronous code easily, almost in a synchronous patt ...

• Asynchronous Execution in ADO.NET 2.0 In ADO.NET, when performing bulk database operations, the thread that is executing it will wait for the database operation to complete and proceed the execution of other lines. If the database operation is bulk and complicated, the amount of time the thread waiting will be more. To answer this, ADO. ...

• Function in predicate produces different execution plan Hi Tom Greetings from the great state of Indiana home of the Indiana Oracle Users Group (INOUG), you need to come back and visit. DB Version: 9.2.0.4 on UNIX I have a simple query that uses what turns out to be a constant on the right side ...

• LINQ and Deferred Execution Charlie Calvert says that understanding deferred execution is a rite of passage that LINQ developers must undergo before they can hope to harness the full power of this technol ...

Next: move one column's data to another column