0

I searched on creating non clustered index with included columns for sybase database. But I don't think "include" is allowed while creating index. Is there any equivalent in sybase?

Improve this question

1 Answer 1

Reset to default
2

No. Sybase doesn't have any equivalent to the INCLUDE statement.

Improve this answer
2
  • So there is no concept of having included columns in non clustered index in sybase? Thanks for answer Simon
    – Delta
    Mar 21, 2012 at 13:28
  • No, the equivalent would be just to have all the columns in the index, even the ones that aren't being searched/filtered on. Bit of a waste of space, but since it only affects internal (non-leaf nodes) of the B-tree index (and it's only useful on some indexes, not all), I can't see it being a high priority feature to be added.
    – Simon Righarts
    Mar 21, 2012 at 20:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.