Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the insight here.
I did actually go ahead and index the table on DELETED() to see if there were performance benefits, and boy were there? an increase in speed of around 80% was achieved.
The reason was that most of the queries were pulling in around 10-25 records from this particular table, and around 175-200 of the records not obtained, were deleted. So I do have a happy customer @ the moment.
Thanks for the comments etc.
Kev
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