Link to home
Start Free TrialLog in
Avatar of MarioC82
MarioC82Flag for Cyprus

asked on

Oracle 10g index/paritioning design question

Hi,

I will describe my question as two examples, firstly if we have a table(PERSON assume normalized and all data is relevant) of 100 fields and 90 of those fields are used to query on to answer questions like "how many people are from london" or "how many are from london have 2 children and are male and born between 1980 and 1985". In respect to Oracle how would i go about speeding up such query's where so many fields can be included. What kind of indexing can be used.

The second question is in regards to partitioning, if i have a table where data is inserted repeatedly every minute, i have 10 processes working on this data but all processes need all the data, does this mean this table is not eligible for partitioning?

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Piloute
Piloute
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MarioC82

ASKER

Good questions raised after much thought i had to award points to all answers as they made me ask the right questions.