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?
744What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
814On 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?
775Post New DB Development Questions
Explain about xml databases?
Explain about relational database management systems?
Explain about query and reporting.
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
Write short notes on manual refreshes.
What is DB Development software?
What is the physical representation for a many-to-many relationship?
Explain about a primary key?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
How long can an error message be in raiseerror function?
How to use timestamp datatypes
Explain about the relational database?
Explain about the hierarchical model of the database?
What are the key features of dbms?
Who are end users in dbms?