I have never used Sybase ASA before in my life. But recently it found its way to my doorstep. I find the database performing at ver low speed. The server machine is a 2.4 GHz Intel Xeon with 1GB ram so it should work smoothly in my opinion.

I have heard about building these indexes and such, but i havent figured out how. Treat me like a newbie, as that is what i am with Databases. If someone could show me howto optimize it with indexes and alike I would most certainly jump for joy.

Version is: ASA
Im not shure what tool to use, i have tried to fiddle with the "Interactive SQL" part from Sybase Central without any luck. Hoping for a good and well explained answer.

Thanks in Advance,