0
0
Rasi
answered Nov 30 '-1 00:00
indexing means arrange in order so it can be easily access when it need .
in database . all data are stored in disk with other store of meta data . means data have data which have needy to acess of data . suppose size of table etc. example . information_schema table
metadata is have also index which used to identify the data , when server requesting it. so suppose server says i need 35 no of record it means database server look for index - primary key - id which have no 35 . its very simple example.
for complex data structure . as like google use indexing to fetch data very easily .it will make a metadata table which have search word and related that word to search result table primary key . so when i type same search text it will directly find it in metadata table . and show up the result easily .
indexing means pre order it so it can be find easily next time.
- MySQL - How to GROUP BY multiple columns ?
- differnece between where clause and on clause in SQL join ?
- What are the join types in join condition?
- I want to calculate time between 2 Dates of a day with multiple rows
- select + delete in single query , how to ?
- how to GroupBy multiple columns in MongoDB ?