#DateForumTypeThreadPost
910 Dec 2015 @ 03:13 PSTDatabaseReplyvery fast query + very fast query = very slow query ???The entire inventory_summary view has about 101,000 records. For an execution plan to assume that a LIKE statement will return 91,000, or 90%, of the records is both impractical in real-world usage...
809 Dec 2015 @ 05:17 PSTDatabaseReplyvery fast query + very fast query = very slow query ???kirthi, the execution plan for the version with the temp table is posted in my "Thanks Todd" post.  (Admins: an essential part of a forum is the ability to uniquely identify and link...
709 Dec 2015 @ 10:58 PSTDatabaseReplyvery fast query + very fast query = very slow query ???talk2soumya, adding "group by 1" had no effect on execution plan, in reality it added a few seconds to execution time (46 vs 52 seconds) I do appreciate everyone's input on this.
609 Dec 2015 @ 09:14 PSTDatabaseReplyvery fast query + very fast query = very slow query ???Thanks Todd, that is interesting. Note that the step you mention (step 4 part 2) is actually the same as query 2, step 3, and that takes a more efficient path (0.04 seconds vs 0.21 seconds). I can ...
508 Dec 2015 @ 03:34 PSTDatabaseReplyvery fast query + very fast query = very slow query ???I am not the DBAdmin, just the primary user, I don't have access to detailed stats. But "inventory_summary" has 101,000 rows, "sales_detail" has 30.5 million. Both of the ab...
408 Dec 2015 @ 01:20 PSTDatabaseTopicvery fast query + very fast query = very slow query ???I am trying to replicate the following query, which takes under half a second, in a more dynamic way to expand it's usage: /* hard-coded Inventory Codes */ /* execution time: 0.5 second */ ...
317 Dec 2013 @ 03:31 PSTDatabaseReplytwo similar tables - very different import speedIt is not a Teradata utility -- my database IDE has an "import table data" function that reads CSV files (my source is a text file -- should have said that in the original post).  Bu...
217 Dec 2013 @ 02:32 PSTDatabaseTopictwo similar tables - very different import speedI have two very similar tables, see below.  On a regular basis, I import about 300,000 records.  The original table required about 90 min to 2 hours to complete the import.  The newe...
106 Dec 2013 @ 01:30 PSTDatabaseTopicbackup or archive commandDoes Teradata DBMS have a command-line function for creating offline backups, something roughly equivalent to "pg_dump" for Postgres or "mysqldump" for MySQL ? Or perhaps a GUI-based backup, lik...