Whenever you have a one-to-many relationship between two tables, you'll have a foreign key reference in the table on the many side of the relationship.
In most database systems, the primary key is automatically indexed; that's not always the case with the foreign key.
To ensure best performance on joins, make sure that every foreign key in the database is indexed. The next candidate for indexing is any column that will be used for sorting — any column that will consistently be used in an ―order by‖ clause of a SQL query.
You'll also want to index columns that will be used for restricting the returned data set, such as those that consistently appear in ―where clauses.
Subscribe to:
Post Comments (Atom)
Image Similarity Search using Vector embeddings and Cosine similarity
Image embeddings capture visual features (shapes, colors, objects, textures) Image embedding models are typically CNN or vision transformer...
-
Database Mirroring and index maintenance in AWS Database Mirroring, the database has to be in the full recovery mode, so all index rebuilds... -
Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
-
1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...
No comments:
Post a Comment