Does the order of Search Criteria matter as far as...
# general
e
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?
k
So I've helped a few people out with performance issues on searches, and it wound up being "how can I search for this differently but still get same results" far more often than order of the criteria
m
It shouldn't matter at all. Ultimately a saved search gets converted by NetSuite into an Oracle DB SQL statement and it's up to the query optimizer to find the best plan.