Data warehousing with Teradata
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment