Mac OSX
Sybase ASA
I transferred my databases folder from my 2.2.5 installation to my 3.0.2 intallation and fired up Servoy Server. I get this warning in the output log:
Performance Warning: redundant index “e_er” for table “servoy_element” in database “servoy_repository”
Other than that everything seems to be working fine.
What can I do to get rid of this redundant index?
Hi Adrian,
I think you should just be able to issue a ‘drop’ index statement like:
DROP INDEX DBA.servoy_elements.e_er
GO
You could do that in Sybase Central too or iSQL or (my preferred tool) Aqua Data Studio. It sounds like you already have a back up but if not make one first but I’d then just go ahead and issue the command. You could also first do a full ‘create’ statement for that table and check what the indexes are currently and why it feels that index is redundant. In Aqua Data Studio there is now also a very nifty tool that will show you the difference between two different tables/tab/schemas, etc. etc. You could run that against the 2.2.5 table and the 3.0 table and that too will tell you something. (I’d HIGHLY recommend the new 6.0 version of ADS by the way. They have really added a BUNCH of sophisticated tools for managing all the various databases that we use. With this upgrade they are charging for it - personal license used to be free - but until the end of the year it is just $149 which is a steal).
yes, I have the same warning, redundant index “e_er” for table “servoy_element”
This appears to be an index of the composite primary key
( I will wait for an “official” response, before messing with the repository )
See my response in http://forum.servoy.com/viewtopic.php?p=37818#37818
Rob