Creating Indexes During Table Creation

index.md

Creating Indexes During Table Creation

We can add an index to a table right when creating that table - like this:

CREATE TABLE <table_name> (
    ... column definitions,
    INDEX <index_name> (<column>)
);

Please note that this is supported when using MySQL but it won't work with PostgreSQL.

references.md

References

Archived from: Schwarzmüller, M., & Lorenz, M. (2021, November 17). More on Creating & Dropping Indexes [Note]. Udemy. https://www.udemy.com/course/sql-the-complete-developers-guide-mysql-postgresql/learn/lecture/28926790