0
I recently circled a EXPLAIN ANALYZE
in my database which is fairly large, about 800mil records in some tables, and I noticed that the indexing methods adopted were not the best. I always let the bank decide what was the best way to index the records, only I have noticed that it is something common the error of choosing the method, so:
There are good practices for indexing files in the database?
Knowing my data set, how can I know which is the best indexing technique?
There are tools, besides the BD itself, that can help me?