How can you tune SQL statements?
Answers were Sorted based on User's Feedback
SQL Statements can be tuned depending on the Database,
different DBMS provides different types of the execution
plan, Oracle provides "Explain Plain" which explains the
cost of the query. Using which we can estimate the cost and
make the necessary changes like creating indexes........
| Is This Answer Correct ? | 0 Yes | 0 No |
What type of driver you use in real-time projects?
Which database is used for java?
What is metadata in programming?
What is a jdbc connection pool?
What are the sailent features of JDBC 2.0?
What are the steps involved in establishing a connection using jdbc in java?
What are the differences between execute, executequery, and executeupdate?
Why we use while rs next ())?
what does batchUpdate does?
i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me
How do I load a database driver with JDBC 4.0 / Java 6?
What does the jdbc connection interface?