Answer Posted / balakrishna
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 |
Post New Answer View All Answers
What is device controller?
What is the meaning of “dirty read” in the database?
What is hbm xml?
Explain in detail about JDBC and its general features?
What is metadata in jdbc?
What is an encrypted internet connection?
What is isolation level? How to set it?
What is drivermanager in jdbc?
How will you perform truncation using JDBC?
What are the types of jdbc drivers that exist?
What driver should I use for scalable Oracle JDBC applications?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
How to make updates to updatable result sets in jdbc?
What is jdbc and explain jdbc architecture?
What is the JDBC syntax for using a literal or variable in a standard Statement?