I'm getting ready to enable fti on sql 2k5. The tables I care about do not have single-field indexes, so I'm planning to add them. I've tested this in a limited way, and do not see any effects that would require changing the applications running against these tables, but I'd really like a sanity check on this. Is there something I should be looking at and haven't
The tables have primary indexes now. For example:
invoice table has 2 fields in its unique primary key:
- invoice ID
- customer ID
invoice items table has 3rd columns:
- invoice ID
- customer ID
- item ID
I've simply added a single auto-increment bigint column to each table, and changed the primary index to that column.
The possible issues that come to mind are that adding, deleting or updating records would somehow find the wrong row, or add a duplicate. but since the programs didn't do that before (and sql server would have thrown a fit if they did), surely there is no reason to believe they would start doing so now.
All this sounds way to easy, and I'm worried I'm missing something really big. Any thoughts or suggestions
Jeremy