create index in the database table to make your result response faster


The CREATE INDEX statement is used to create indexes in tables.
Indexes allow the database application to find data fast; without reading the whole table.
An index can be created in a table to find data more quickly and efficiently.
The users cannot see the indexes, they are just used to speed up searches/queries.
here in the below you find a video how to create the indexes in database

https://www.youtube.com/watch?v=zmAMXSr8zio

Comments

Post a Comment

Popular posts from this blog

Merge JS and CSS file to make your codeigniter website faster using CARABINER library

Carabiner is a library for managing JavaScript and CSS assets. It's different from others that currently exist (for CodeIgniter, anyway) in that it acts differently depending on whether it is in a  production  or  development  environment. In a production environment, it will combine, minify, and cache assets. (As files are changed, new cache files will be generated.) In a development environment, it will simply include references to the original assets.
Read more