Is there a way to create indexes in the NS database?

Not on your own, I don't think. If you tell them that the particular search performance is the end of the world and continue to harangue NetSuite support enough, I have had them index certain tables for me at a prior company many years ago fwiw.

Better than not being able to do it at all... great to know, thanks. I will open a ticket.

Directly, no. But as James stated, if you have a very poorly performing record type, or searches, and you can demonstrate how they impact performance and overall usability, NetSuite can apply various tweaks to the database. It may not always be an index, it could be stored hints in a query, or some other adjustment. The only downside with whatever they do is if you ever get migrated to a different cluster or server, those things may not be preserved as they aren’t technically part of your environment’s configuration.

Got it. It is a query we are running using the REST API /suiteql endpoint.

yes, good point Scott, also sometimes it gets undone and you have to go through the whole rigmarole again when you have your bi-annual upgrades. So a lot of times not worth it unless you reeeeeeeeeally need it IMO.

right, it’s worth keeping a record of the support case and any emails with netsuite saved, as if the performance reverts, you can get support to reference what was done previously

@James Morris WDYM? Upgrades also could undo it?

if they update their Oracle database version, yes. Though each new version of Oracle gets better and better at auto-tuning performance, which is partly why things like stored hints are not preserved. They sometimes aren’t needed, or a different approach is needed after an upgrade

Hmm, got it. I usually have a problem with finding information like that... Like, did you know this from experience or is it written somewhere?

nothing that is published for general audience, just things that support told me, somewhat off the record (on a phone call)

I have no idea why Oracle wants it to be this way. I sometimes spend like an hour trying to find something, like a table name, that should be easy to find.

and, as James mentioned, we did lose those performance enhancements periodically. When it happened, we knew right away, as searches would start timing out again.

And you talked to the support again?

Yes, every time we had to go back to support, though they were able to get it back working again quicker in subsequent cases.

Yeah, but better than taking a lot of time every time it happens.

best of luck!