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!
Indexes take space, but the main reason for the large database size is unused spaces.
Use "SHUTDOWN COMPACT" or "CHECKPOINT DEFRAG"
Thank your very much for this tip! :-D
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.