Quote:
Originally posted by LND
what is interesting in this example is the fact that table is FIXED width.
If sybase is able to utilize this fact then it is no surprise it is fast, for example:
...SNIP...
This will probably not contribute anything usefull for the problem discused in this thread, but I'd like to add this because you repeat this "fact" in a couple of your replise here. What makes you think the record size of this table is fixed? with 99.99% accuracy I can say the records are of variable size in this table. For two reasons: