People,
Possibly more of a SQLserver question than CF, but hope you can help anyway.
I'm from a DB2 background, and trying to learn CF based on that - probably a bad start. I have a table ( c 30000 rows ), which gets hit by many different searches. Is there a limit to the amount of indexes I can build on this. I get an occasional index error, eg "Could not find the index entry for RID '369a7e0020010e0504d'"....
Is this because of having too many indexes? I have one PK and do need the other 4 secondary....
Cheers,
K
Possibly more of a SQLserver question than CF, but hope you can help anyway.
I'm from a DB2 background, and trying to learn CF based on that - probably a bad start. I have a table ( c 30000 rows ), which gets hit by many different searches. Is there a limit to the amount of indexes I can build on this. I get an occasional index error, eg "Could not find the index entry for RID '369a7e0020010e0504d'"....
Is this because of having too many indexes? I have one PK and do need the other 4 secondary....
Cheers,
K