Take the 2-minute tour ×
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.

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
add comment

1 Answer 1

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
add comment

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.