Is it recommended to use aerospike to filter on some field

I have around 2 millions records, each record having 10-12 fields(mostly are string). Now I want to filter records on the basis of some field. Is it advisable to do this using secondary index or some other better option is available? Also, how much time would it take to get all the records/just keys (after applying the filter)?

Thanks in advance.

Cross posted: https://stackoverflow.com/questions/60931266/is-it-recommended-to-use-aerospike-to-filter-on-some-field/60936695#60936695

© 2015 Copyright Aerospike, Inc. | All rights reserved. Creators of the Aerospike Database.