Remember that if you dont use an index on a colum and you search by that
criteria, there would be a whole table scan :(.
Its recommended that you always index those columns that appear on a search
and/or an order (where column_a='yyy' order by column_b) and those involved
on joins; generally
Hello All,
Need a suggestion for this:
We have tables which have very few number of rows ( less than 600 ). For a long
period of time the number of rows are going to remain almost the same.
1) Is it better to index the columns of such tables?
2) There are Joins on this table and then a