Howdy!

Danger! Danger!

Before you go adding indexes willy-nilly, you have to have some understanding of the data and how it is being used. Indexes do not automatically give you increased performance. In fact, in many cases, indexes can slow things down.

Is the database transaction heavy or no? Having many indexes in a database that has heavy insert/update/delete activity can really bit you, as those indexes must be maintained in parallel with the table changes.

On the other hand, if the data is relatively static, used mostly for queries, carefully crafted indexes can make a dramatic improvement in performance. Poorly crafted indexes could do little but consume space.

Another factor you must keep in mind is how the query optimizer works for the DBMS in question. Indexes need to be crafted (there's that word again) with that in mind, if they are to be effective.

Proper indexing is something of an art; it's one of those things that help keep database administrators occupied. As access patterns change indexes may need changing. I'll be bold and claim that you aren't going to find the general solution you seek. Sorry about that.

yours,
Michael

In reply to Re: Autogenerate SQL Indexes? by herveus
in thread Autogenerate SQL Indexes? by knoebi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.