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); |