Home » RDBMS Server » Performance Tuning » Creating index on base tables of a view
Creating index on base tables of a view [message #485690] Thu, 09 December 2010 08:38 Go to next message
mmtr
Messages: 4
Registered: April 2009
Location: DELHI
Junior Member
I have a view on base tables holding historical data for previous 60 months(one table per month) with union all operators.
Please suggest whether to create index on those base tables will improve performance or creating a primary key with disabled novalidate will improve for retrieving data?

The view has around 8 million data and used as a fact table with 4 dimenssion tables.A DTS package from MSSql side refreshes OLAP cube by retrieving data from these tables in oracle.

Regards,
Megh

Report message to a moderator

Re: Creating index on base tables of a view [message #485691 is a reply to message #485690] Thu, 09 December 2010 08:43 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please suggest whether to create index on those base tables will improve performance or creating a primary key with disabled novalidate will improve for retrieving data?

Since it is IMPOSSIBLE to tune unseen SQL, you need to provide more facts
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:

Report message to a moderator

Previous Topic: Expensive Query
Next Topic: Query using rownum in where cluase with millions of records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 12:22:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.