what is optimizing data..??

[roozmarry871]

i really want to know what is optimizing data.? anyone can explain it in simple words please..

[dgavin]

It depends on the type of optimization you mean, Optimizing the data for speed of access, or optimizing the data for less storage.

The first case usually involves various technicues such as replicating data, indexing, indexing with non indexed (included) columns, algorythimic patterned storage, etc...

The second usually involves removing all redundant data, using built in (or external) data compression, removing referencial integrity keys (not recomended), etc...