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

Posted on 2013-10-18
Medium Priority
Last Modified: 2013-11-08
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.
Question by:pardeshirahul
  • 2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39583748
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.
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 39583760
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.
LVL 23

Expert Comment

ID: 39583811
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.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question