Thursday, January 27, 2011

table has UPI on EMP no. I wrote a query in which i used deptno in emp table? How many amps gets this data?

Even thouh table has Primary Index , my SQL query written on
dept no on which there is not index.... So its a Full table scan

No comments:

Post a Comment