Question on keys

easabangan

Hi,

Have a question regarding on the size that will be added if you are creating new key on a table. For example This are the values of the database.

Database size = 65000gb
Table that you will add a key = 7gb, records = 5million


How many percent will it add per key that you will add?
Thanks for any idea.

Marije_Brummel

It depends on the amount of fields in the key and the fieldtypes.

Are there any other keys that looks similar?

Why is size so important for you?

easabangan

Sir Mark,

It is very important because of the license limited size, here are some information :
- License is limited only to 65gb database.
- The used size is already reach 88%.
- I have lots of keys too add in the table.

I am feared that the database will reached the limit if I add this keys.

How many percent per field in a key will be added in the size sir?

Thanks for the reply

Marije_Brummel

I see.

You can request a special license to expand to 128Gb or more.

Anyways: Have a look in the other indexes and find a similar one, look at the size and your answer is there.

Otherwise you can try archiving or maybe removing some overhead in your database.

easabangan

Ok,

Maybe I will just add it one by one, so that I can monitor the size of the database.

Thanks again sir.

kriki

In your case (until you get the license fixed), you might start to optimize the tables to shrink them a little.