Postgre database ignoring created index ?!
- by drasto
I have an Postgre database and a table called my_table. There are 4 columns in that table (id, column1, column2, column3). The id column is primary key, there are no other constrains or indexes on columns.
The table has about 200000 rows.
I want to print out all rows which has value of column column2 equal(case insensitive) to 'value12'. I use…