Error on index creation if column number > 16


Author
Message
Michel Levy
Michel Levy
StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)StrataFrame User (437 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
Trent,

I do not debate philosophy: don't forget that English is not my native language, and that BOL I refer to is in French. So sometimes (often) I may hurt someone, and I apologize for that.

Especially here, I've found 2 differents meaning of "covering index". One refers to index which includes all columns, and another to index where all columns are either in key columns, either in include columns. Also found a third usage of "covering index", where it means index with include columns, no matter of the # of them. Even in French, it is confused for me Crazy. Trying to dicuss it in English is very difficult.

Thanks again for your patience (and for StrataFrame)

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Michel,

There is no apology necessary and I was never frustrated, offended, or anything of the sort, though my post was a little bleak.  When I was posting I was trying to get out the door, so I did not elaborate on any of my explanations.

Yes, you are 100% correct that terminology and nomeclature can mess things up when having these types of discussions, even when English IS your native language! Hehe

I think that we are on the same page here.  Long story short, we will be introducing the INCUDED columns in a near release as we are also adding additional data type support for some other users as well (yes, that is you Keith if you are reading this post).  We are going to be careful on this build prior to releasing to make sure that there are many unit tests in place to make sure nothing is broken along the way.  But this is something that is very beneficial and even something I have recently used as well.  So there is definitely a need.

Thanks for your continued support and I apologize if my post seemed harsh, as that was not my intention at all!

Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Trent L. Taylor (02/14/2010)
...Long story short, we will be introducing the INCUDED columns in a near release...




It happens that I am in the process of reviewing some of my queries for performance optimization and many of the INDEX creation suggested by the MS SQL Server Management Studio have the INCLUDE clause, so I believe this will be a must needed request.



Please include me in any possible early beta on this one. Hehe

Edhy Rijo

Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Trent L. Taylor (02/14/2010)
...Long story short, we will be introducing the INLCUDED columns in a near release...




Hi Trent/Dustin,



Do we have an ETA on this feature? if not available soon, any suggestions on how could I add the creation of this type of indexes in the DDT?



PS

I am not using xCase anymore only the DDT and don't want to have to use 2 different tools to take care of the structure updates, so I need to rely only in the DDT for automated updates at customer site.


Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search