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 |
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
What is Type-1 Driver and when this driver is used?
Under what circumstances, that all four drivers are used?
What is JDBC Driver interface?
What is CLOB and BLOB datatypes in JDBC?
Explain what should be done when a SQL exception is raised?
why we don't use the type 2 driver for connect to the database in jdbc?
What is jdbc dialect?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
What is a datasource in java?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
Is jdbc and orm?