Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question

1 Answer

up vote 2 down vote accepted

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

share|improve this answer
So there is no concept of having included columns in non clustered index in sybase? Thanks for answer Simon – Delta Mar 21 '12 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 '12 at 20:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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