DEV Community

Krixnaas
Krixnaas

Posted on

DataBase Table Indexing

#mysql #database #php #laravel

If you have large number of data and your query is taking long time to execute. Database table indexing could be helpful.

Primary key is automatically index, likewise you can add more indexing keys (column_name) that you frequently used for query.

Image description

Top comments (0)

Read next

alexmercedcoder profile image

All About Parquet Part 06 - Encoding in Parquet | Optimizing for Storage

Alex Merced -

aman_yadav profile image

Local AI Knowledge Base with Next.js, Ollama, and PostgreSQL

Aman Yadav -

nozibul_islam_113b1d5334f profile image

Database Monitoring: Importance, Tools, and Best Practices for Performance Optimization

Nozibul Islam -

stringintech profile image

Optimizing PostgreSQL Mass Deletions with Table Partitioning

stringintech -