Concept of indexing
Posted on 2009-04-16
I want to know the practical usage of doing indexing on a table and how it improves the excuation time of a query.
We were having a table which was taking a considerable amount of time to load, so my colleague put an index over a column called EVENT DATE and he also truncated this EVENT DATE.
I just want to know the basics of indexing, i could have googled it, but I want to know the usage and working in real time scenario from you experts.
Thanks in advance.