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

Explain is fact table?

974

Start a batches with in a batch?

1030

What are the stages that are required in data warehousing?

1018

What is the difference between ods and oltp?

1079

What is data stream and data adaopter?

1135

What is data analytics in simple terms?

1266

How to eliminate duplicate rows from flat file?

990

What is aggregate fact table?

1042

I have two universes created by two difference database can we join them in designer & report level? How

1035

What are the types of dimensional modeling?

1111

Which columns go to the fact table and which columns go the dimension table?

1020

In document how to create metrics?

1045

What is metadata in context of a datawarehouse?

1128

Explain me what is vldb?

982

Difference between PowerPlay transformer and power play reports?

2560