I've been pointed to this script from several places which apparently helps with designing indexes in Microsoft SQL Server: http://indexanalysis.codeplex.com/
The problem is I'm using Sybase ASA 11, which seems to use a slightly different implementation of T-SQL than the one used by MS. I'm getting all sorts of errors when I try to run the script.
I know enough about database tuning to tell where to put indexes, and that's about it. I'm a programmer, so I don't know about it as much as I'd like to.
My question is: Is there anything similar to this tool for Sybase? I need to know where to put indexes without going to each and every query (if I can avoid it).