They can be very useful, especially for nullable columns.

asked Mar 02 '11 at 19:11

ara's gravatar image

ara
395868791


One Answer:

Hello Ara,

There is a feature called Extended index management in the 'Features and ideas' list, that implies implementation of expression-based and partial indexes. For now, there is no votes for it, but this can be easily fixed, I suppose =).

answered Mar 02 '11 at 21:50

Dmitri%20Maximov's gravatar image

Dmitri Maximov
22111211

Haha. Fixed ;) Unfortunately I don't have too many votes remaining!

(Mar 02 '11 at 21:53) ara ara's gravatar image

Right. But that limitation adds the value to the voting process and results, as developers also have limited resources.

Let's wait and see, the feature might be requested by someone else.

(Mar 02 '11 at 22:06) Dmitri Maximov Dmitri%20Maximov's gravatar image

may be merge Extended index managment with Clustered index not based on primary key?

(Mar 03 '11 at 04:38) pil0t pil0t's gravatar image

Nice idea, will do.

(Mar 03 '11 at 05:09) Dmitri Maximov Dmitri%20Maximov's gravatar image

Failed. Merging feature is unavailable for our current pricing plan (we use the 'Free' one).

Although, the feature has already gained 6 points for 10 hours. Let's wait and see the final result.

(Mar 03 '11 at 05:19) Dmitri Maximov Dmitri%20Maximov's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA