cancel
Showing results for 
Search instead for 
Did you mean: 
simone.cossu
Level 7

How can I do quick query to database using nsql?

Hi everyone.

I'm doing some queries to database but I obtain the data after a long time.

Example,

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.

Simone

0 Kudos