Search results for query: *

So you are getting a product join then or is it a performance problem? You didn't explain what the problem is or what you want to accomplish. I don't know exactly what you are trying to do, but I think you might need to normalize your tables to 3rd normal form.

There are many solutions. General solutions that come to mind: 1. Do nothing - does the NUPI cause a performance slowdown? If not then leave it. 2. Add another column to the NUPI to decrease skew. You didn't say what the other cols are but this might work if you add a NUSI on the original...

You can download the demo version from teradata.com. This includes the ODBC drivers.

select col1, col2 from foo qualify rank() over (partition by col2 order by col1, col2) =1 order by 1

I am not sure why you want this SP, but anyways the WHILE needs a DO as well as an END WHILE. As in WHILE x > 0 DO something END WHILE;