Can you please check this DB Model and provide insights on how we can index the tables

Can you please check this DB Model and provide insights on how we can index the tables to improve performance.

Is there any other tips you can provide us to improve performance in this kind of design.
DBModel-modified.jpg
pardeshirahulAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
What and how to index depends on how the application uses the tables.

You really  cannot say what indexes are necessary based on a model.

Tuning is more of an art than a science.  Pick your worst performing queries and tune them individually.  Keep on until you are satisfied but be careful to not over index...  Too many indexes can also hurt performance.
0
slightwv (䄆 Netminder) Commented:
Other things you have to take into consideration:
Number of rows in a table.
Cardinality on the columns you are thinking of indexing.
Type of index (BTree, Bitmap, Reverse Key, etc...).
Order of columns in the index.  Should the index be (col1, col2, col3) or (col3, col1, col2) or should they really be two indexes?

You have to know your data and how the application is using your data before you can start thinking about indexes.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavidSenior Oracle Database AdministratorCommented:
I'm rusty on the notation.  Within a section, do you have one, or multiple hyperlink?  Can a hyperlink populate multiple sections?

I'm speculating (again, rusty), you may be unnecessarily replicating the parent PK down to each child.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.