Can 2 tables have same index name?

Question

Index names are specific to each table. You cannot have two indexes of the same name in one table, but you can have many indexes of the same name, one for every table. Index names are irrelevant for day-to-day performance. 8 сент. 2011 г.

Can indexes have the same name?

Because the index is stored in the table pg_class. Within that table there is a composite key comprised of the index name and the namespace, which is why you cannot have two indexes with the same name belonging to the same namespace.

Can we create two tables with same name?

You can have tables of the same name only if they are in separate databases, and you use the database name as a qualifier.

Can we have same name for index tables in SQL Server?

All indexes within the Maximo schema must have unique names. On SQL Server only, it is possible to create multiple indexes with the same name on different tables from the back end. This causes the ConfigDB utility to fail with the following error: The same index name is used on different tables in the native database.

Can we create index for two tables?

The answer is no. I can't create a index on multiple tables. My solution would be to make a table instead, and in my case a view also, or I could just optimize the SQL code.

Expert · Answer