Partition table,bitmap index,sequence,table function,sql loader ,function

What Oracle features can be used to optimize my Warehouse
system?

Question Posted / abhishek soni

Answer Posted / abhishek soni

Partition table,bitmap index,sequence,table function,sql
loader ,function like cube,roll_up etc.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of partitioning?

1049

What is core dimension?

1061

Is union transormation is active transformation?

975

Where we use surrogate key explain with example?

1129

Explain why dimenstion tables are denormalized in nature?

920

What is your spectra photometer working principles?

982

Describe the differences between a data warehouse and data mart.

1001

Compare aggregates and data marts

2765

What are aggregate transformation?

1037

How can you communicate with web server (apache or iis) from coldfusion?

1119

What is the advantages data mining over traditional approaches?

967

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2469

Is there any rownum object from which we can do this?

945

Explain where do we use semi and non additive facts?

1018

How can we load the time dimension?

1199