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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Development Interview Questions

What is the maximum length of an extended property?

0 Answers  


What is an application role and explain a scenario when you would use one?

0 Answers  


You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  


hi in which phase of mload can i use .FILLER

1 Answers   IBM,


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  






what is difference between primary key and unique key ?

2 Answers  


What is a database development?

0 Answers  


what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,


How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  


how to find the first two highest salaries in deptno in emp table

2 Answers  


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).

0 Answers  


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  


Categories