http://www.w3schools.com/sql/sql_create_index.asp
My idea; field index just for frequently used table for searching. since updating is slow, (see note) no index for frequently updated data .
Indexes allow the database application to find data fast; without reading the whole table.
Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). So you should only create indexes on columns (and tables) that will be frequently searched against.
No comments:
Post a Comment