Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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
languagesql
CREATE INDEX Realm_parent_id ON Realm(parent_id);
CREATE INDEX Realm_fullPath ON Realm(fullPath);

...