thats a very wide open question and hard to even suggest where to start
Do indexes provide any benefit?
Have you configured dbms.memory.heap.init_size and dbms.memory.heap.max_size appropriately? And dbms.memory.pagecache.size ?
August 🏄 🏖️ 🏊
