I'm doing some queries to database but I obtain the data after a long time.
select * from alert where reviewed = 1
select * from alert where alertid = 123456
these queries complete after 5 minutes.
I understand that is related to table indexes (probably these fields are not indexed)
but there is a workaround? Can I use a database "view" or something similar?
Thank you in advance for any suggestion.