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 protocol does jdbc use?
What happens if connection is not closed in jdbc?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
How many types of jdbc drivers are available?
Diff bet.. Function and Trigger?
Why do you use a data source object for a connection?
How can you tune SQL statements?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
What is type 4 jdbc driver?
What is CLOB and BLOB datatypes in JDBC?
How many categories of jdbc drivers are there?
What is a merge field?