#DateForumTypeThreadPost
213 Jul 2016 @ 10:58 PDTDatabaseReplyNeed to generate a row number like columnFor solution to youre query 1. 2nd question is not clear to me SELECT LOCATION, ORDER_ID, CLASS, DATE, ROW_NUMBER() OVER (PARTITION BY  LOCATION, ORDER_ID  ORDER BY LOCATION, ORDER_...
113 Jul 2016 @ 05:40 PDTDatabaseTopicAvoid all-row scan in driving table using NUSI Hi I am gettnig all-row scan even after using a secondary Index at the driving table. I am not sure if my approach is right , so please help me out here.   Sample snippets, we have ...