#DateForumTypeThreadPost
308 Dec 2014 @ 10:35 PSTDatabaseReplyHelp with avoiding redistribution using a hash index Thank you Dieter. I modified the query as you suggester(clever!), changed the varchar columns to varchar(95) for address and varchar(25) for name, created a join index and collected stats on the...
201 Dec 2014 @ 06:24 PSTDatabaseReplyHelp with avoiding redistribution using a hash indexThank you, I changed the type of Source_Name_Txt to VARCHAR(30) and Source_Address_Txt to VARCHAR(95), and created join index. The query completed in 1 hour 25 minutes. Explain plan looks...
101 Dec 2014 @ 09:58 PSTDatabaseTopicHelp with avoiding redistribution using a hash index Hi,   I am working on a query to combine multiple rows with overlapping dates for the same information. I use partition by and reset when to achieve this. However, even though the t...