Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 522 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 264 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 228 Portuguese
SQL and DB performance
I am executing multiple complex select queries on direct tables as of now data is very less so everything is fine but later in future once data gets increased it will impact database and SQL cost too.
Looking for an alternate instead of hitting original tables. Need solution for execute select statement without hitting original table.
Answers
-
There are plenty of ways to enhance performance, your question does not have any context information in order to try to figure out how to solve a problem that does not even exist right now...
"Hitting the actual tables" is usually not a problem if it is done the right way.
Some things you may consider:
1) Proper indexing can help you get just the rows you need without having to read the entire table
2) Materialized views can have summarizations pre-calculated, avoiding reading data from the original tables (at the expense of regularly updating those materialized views)
Explain more in detail what problem you are facing so we can provide more realistic help.
