PDA

View Full Version : what is optimizing data..??



roozmarry871
2012-Sep-18, 12:24 PM
i really want to know what is optimizing data.? anyone can explain it in simple words please..

dgavin
2012-Sep-19, 12:52 AM
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...