Removing the indexes would just have an effect on query performance,
so if you're not querying much it wouldn't matter (and would make
writes faster). You can also add indexes back at any time to get the
query performance benefit. Other things in the system may query by
those columns, but unless you notice a slow down then you're good to
go...
-David
On Oct 9, 2009, at 11:56 AM, Steve wrote:
I believe these might be used for sync between instances. So, let's
say you have no interest in ever doing so.
Is there any harm to deleting all of the timestamp indices in all of
the tables, in order to gain some measure of performance back? Are
they used for anything else other than syncing which would make this
a very bad idea?
Steve
