How to Optimize NetSuite Saved Search Performance with Indexed Fields?

To significantly improve the performance of NetSuite saved searches, particularly for transactions, it is crucial to filter results using fields that are typically indexed by the system. While NetSuite's exact indexing strategy can evolve and a comprehensive, exhaustive list of all standard indexed fields is not consistently published, the following fields are generally considered strong candidates for indexing on transaction records and can be relied upon for optimizing search queries. It is important to note that this list does not include many boolean filters; these can often be assumed to be indexed, or their indexing may not offer significant performance benefits if the data distribution (e.g., 50% true, 50% false) does not lend itself to efficient indexing. Additionally, this overview does not cover many internal or compound indexes that NetSuite may utilize. Commonly indexed transaction fields that can enhance search performance include: Account, Class, Created From, Currency, Date, Date Closed, Date Created, Date Due, Department, Employee, Expected Close Date, Item, Job, Last Modified Date, Lead Source, Location, Name (e.g., customer, vendor), Number, Opportunity, Partner, Payment Method, Period, Price Level, Promo Code, Sales Effective Date, Ship Via, Status, Subsidiary, Terms, Type, Unit, Win Loss Reason. By prioritizing filters on these types of fields, users can effectively optimize their NetSuite saved searches for faster and more efficient data retrieval.