troubleshooting Question

how to reduce query time for un indexed table

Avatar of NiceMan331
NiceMan331 asked on
Oracle Database
15 Comments3 Solutions245 ViewsLast Modified:
hi
we purchased POS , where they provided a solution that daily basis every point of sales will send its data as text file
then to append it all into one table where it is un indexed and have too large records til now , and every day it is increase day by day
i don't like to touch the table , but when i do any query it takes minimum 30 minutes to finish
how i do to reduce time of query ?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros