It's all about the update...
EDIT: 9/9/2004: Well that wasn't much of an explanation. What the hell are deltas.....is it a place in Mississippi where they have great music and food? Well, yes....but deltas here are meant to describe a process, where by a database table has a set of data WITH a primary key, and a file is supplied daily with “updates“ (and I use that term loosely) that need to be applied to the table. Both the file and the table do not have to have the same structure, number of columns, datatypes and/or sizes...but the MUST have a...
I'd like to expand this list with anyones comments. Thanks! And if anyone knows the M$ link that discusses how they optimized SELECT * for existance, I'd appreciate a linke. Thamks again!
Why you shouldn't
1. Effeciency: Only the data you need Reduces the amount of I/O that has to occur
2. Better use of indexes
May use Index intersection or make use of covered indexes
3. Isolate code from Table object changesFor example, the following would through an error INSERT INTO myTable99(Col1, Col2, Col3,ect) SELECT * FROM myTable00 WHERE
4. I get a chuckle when Access developers say DELETE * FROM mytable99 'nough said
5. Increases network traffic, requires more...