MarioC82
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER