Does the order of Search Criteria matter as far as performance goes?
Let's say I wanted to find all Sales Orders over $100 from yesterday.
If I added Total > $100 as the first criteria and Date == Yesterday as the second criteria... would that perform any differently than if I listed them in the opposite order?
In my mind, NetSuite is looking through 1,000,000 Sales Orders, but I'm not sure if it then cuts that 1,000,000 down to 500,000 that are > $100 (based on the first criteria) THEN cuts that down to 10 that were from Yesterday
Or if it starts with 1,000,000 Sales Orders and then cuts it straight down to the 10 that were >$100 AND from Yesterday?