cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community