var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a table which has around 40millions of records. There are some program that going to update records in that table which don't have indexes.
This program updates the table with full record update not to specific fields.
column1 column2 column3 column4 column5
1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
updating program update entire row even though it needs to update column1 and coumn3.
Can any one advice me is this a right way to do?. I need a clear idea to convince my to how to proceed on this.
Thanks for your valuable time on this.
before going into a long answer, which version of Informix engine is this ?
View Tag Cloud
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors