You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
525What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
590On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
566Post New DB Development Questions
What is database design and development?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about the database management systems.
Why does this query return 0?
Explain the process of the user request and data generating?
How you can make a parameterized view?
Explain about the relational database?
Can an extended stored procedure be called from inside a user-defined function?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
State the acid rules?
How to combine two function together?
Explain about normal forms?
What is an application role and explain a scenario when you would use one?
How to replace not in with not exist?
How is data stored in dbms?