I used to work on Oracle and am new to Sybase. It looks like Sybase has fewer features than Oracle and I have a few questions regarding to Sybase ASE11.9 and ASE12:
1. With Oracle, I can use database link and tnsname to set up the distributed environment so that I can access data located in unix boxA from Unix boxB. Does Sybase ASE providing the similar feature? If so, what steps need to be performed?
2. Oracle provide partition feature since version 8, how about Sybase? Can I partition a table by column with Sybase ASE? I read some documents and it sound like Sybase partition concept is different to Oracle.
3. Any recommended web-site for sybase DBA so that I can easily find out syntax, concept, definition, etc? Might be I am new to Sybase, I found that Sybase online manual is not as friendly as Oracle.
2. Alter the table to partition, then create a clustered index in your date fields. This cluster index will dispatch the data in the partitions. FYI: ordering the data by date will decrease perf, because only some partitions will be used in a specific time. To historize, prefer the use of several tables + view with unions in these tables