Indexes-Problem???

2010-04-29
2014-01-19
  • Larissa Janssen

    Larissa Janssen - 2010-04-29

    Hallo,

    i have DB from 4 MB with Data (without indexes). With indexes (< 15 number) is my DB 128 MB.
    This is samples from my index:

    CREATE INDEX PLUS.IDX_SUBSCRIBER_EMAIL_ISDELETED ON PLUS.SUBSCRIBER(EMAIL,PASSWORD,ISDELETED)
    CREATE INDEX PLUS.IDX_EVENT_FROMTIMESTAMP ON PLUS.EVENT(FROMTIMESTAMP)

    Unique indexes are ok.

    Please check this.

    Thank your very much!

    Larissa

     
  • Fred Toussi

    Fred Toussi - 2010-04-29

    Indexes take space, but the main reason for the large database size is unused spaces.

    Use "SHUTDOWN COMPACT" or "CHECKPOINT DEFRAG"

     
  • Larissa Janssen

    Larissa Janssen - 2010-04-29

    Thank your very much for this tip! :-D

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks