Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>>>Thanks Borislav, that's it.
>>>The decision to use non-production indexes was made before my time...
>>>I think one reason was to speed up appends by disabling indexing.
>>
>>:) Adding 10 records and reindexing 100,000 is no savings. :)
>>
>>Of course since there's a UDF in the index, that could make things slow enough to warrant such a tactic. ;)
>
>But, but, You need to reindex them anyway :-)
Adding 10 records to an existing table with indexes does not require a reindex. The new records' keys are inserted without a complete rebuild.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only