THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
New indexes shall be created to improve overall performance.
PostgreSQL
Code Block | ||
---|---|---|
| ||
CREATE INDEX Realm_parent_id ON Realm(parent_id); |
...
CREATE INDEX Realm_fullPath ON Realm(fullPath); |
...
CREATE INDEX Realm_fullPath_startsWith ON Realm USING GIN (to_tsvector('english', fullPath)); |
Oracle |
...
MySQL | MariaDB
Code Block | ||
---|---|---|
| ||
CREATE INDEX Realm_parent_id ON Realm(parent_id); |
...
CREATE INDEX Realm_fullPath ON Realm(fullPath); |