×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Influence of number of indexes on a table

Influence of number of indexes on a table

Influence of number of indexes on a table

(OP)
I'm asking myself if there is a limitation about the number of indexes created on a table ?

What kind of influence on the performance may this have.

For example we have a table with 6M records and 15 indexes.
I'm asking myself if it is a good idea to create a new one to speed up a specific transaction or is it useless ?

RE: Influence of number of indexes on a table

You could have a look into your releasenotes, maybe there is something concerning that. At least in my environment i could not find any limitations concerning the number of indexes. Only the indexsize and number of columns is limited.

Concerning performance: why don't you setup a testszenario and measure the difference?

It is obvious, that a properly constructed index will speed up your query significantly. An additional index has to be managed by the databasesystem and thus creates a certain update-workload when writes are done into that table. You have to find out and decide, if you can notice any major speedimpact in writeoperations.

YOu could also analyse the existing indexes and find out, if there is a way to optimize them. Indexes are evaluated from left to right, so sometimes it is possible to merge indexes, because they both contain certain columns, without having any impact on readoperations.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close