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

Enable the imap in support in xampp server

As default, the IMAP support for PHP is deactivated in XAMPP due to some mysterious initialization errors with some home versions like Windows 98. If you work with NT systems, you can open the file "\xampp\php\php.ini" to activate the php exstension by removing the beginning semicolon at the line ";extension=php_imap.dll". It should be: extension=php_imap.dll Now restart Apache and IMAP should work. You can use the same steps for every extension, which is not enabled in the default configuration.
Read more