Creating Indexes

[Bart Pietercil]

On 3-okt-07, at 20:51, Ruslan Zasukhin wrote:

> On 3/10/07 9:43 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> Hi List, Ruslan
>>
>> How can I modify the name of an index.
>> Now we get errors like index_5 is corrupted on table users, but I do
>> not see a way to identify (easily) what field this index_5 is
>> referring to.
>
>> So I would like to be able to set the name of an index through code.
>> Possible ?
>
> Right now no.
>
> Okay, so we have 2 issues here:
>     * assign names of indexes.
>     * show names of indexes in Vstudio in some way.
>

Absolutely, this will help to get more meaningful errormessages.
I think that it should be possible to have all features of an index  
addressable by the index name.
I think we need two ways to address an index
1) renameIndex(indexedfieldname,newname)
2)rebuildIndex(indexname)
3)dropIndex(indexname)

I also think that I should be possible to maintain more then one  
index (with different collation settings) on 1 field

Bart