Odrzucone

More advance index creation required

10 lat temu • Ostatnio zmodyfikowane przez 10 lat temu • 1

Currently its not possible to define indexes that use a sub length of a column. This is often used for char and byte type fields that are very long.

In mysql you can do the following

CREATE INDEX part_of_name ON customer (name(10));

Głosuj

Odpowiedzi 1
Zacznij od najstarszych
- Zacznij od najnowszych
- Zacznij od najstarszych

Odrzucone

10 lat temu

We would like to keep Vertabelo UI for basic elements simple, so we don't plan to extend it in such cases.

But you can add such index to the model using table "Additional SQL scripts" tab as you can see on picture below.

Odpowiedz
- Czy tak jest?
- Nieodpowiedni
- Spam
- Duplikat
|

Customer support service by UserEcho