#DateForumTypeThreadPost
1305 Nov 2012 @ 08:25 PSTDatabaseTopicprimary index using begin(period)  I have a time-series table with data points that are time periods. I'd like to be able to evaluate the following designs:   create multiset table dropme_t0(   whatever_id v...
1226 Sep 2012 @ 10:11 PDTToolsReplySQL*Plus spool to Fastload via named pipe (Windows) is barely faster than by flat file.Update: further testing shows the ETL server is severely limited by network bandwidth. We're going to resolve that problem first, then I'll repeat this test and post the results here.
1124 Sep 2012 @ 10:55 PDTDatabaseReplyObtain the text of a join index from the data dictionary?Nevermind. I figured it out.   show join index my_database.my_join_index_name;
1024 Sep 2012 @ 10:51 PDTDatabaseTopicObtain the text of a join index from the data dictionary?I created a test AJI at the end of last week, but I've since lost the text of the index. In SQL Assistant, I can see the index as part of the table in the tree view navigation pane, but I can&#...
914 Sep 2012 @ 07:44 PDTToolsTopicSQL*Plus spool to Fastload via named pipe (Windows) is barely faster than by flat file.I've got Fastload opening a named pipe, and I'm redirecting the output from a SQL*Plus script to the pipe in Windows. I assumed this would be far faster than allowing SQL*Plus to spool the ...
804 Sep 2012 @ 01:08 PDTDatabaseReplyDo macros only support ANSI sql? Ok thanks. I was trying to avoid rewriting the whole thing its 1000+ lines in a single select statement. Here goes...
704 Sep 2012 @ 11:32 PDTDatabaseReplyDo macros only support ANSI sql? Ok I've done some testing, and it looks like the Oracle (+) notication for the outer join sytax is the problem:   select * from t_1, t_2 where t_1.some_id = t_2.some_id ...
604 Sep 2012 @ 10:10 PDTDatabaseTopicDo macros only support ANSI sql? Hi all,   I'm trying to run a performance comparison between Oracle and Teradata. I've ported the data from our Oracle database, and now I'm trying to test the procedure...
519 Jul 2012 @ 01:30 PDTDatabaseReplyReturned Set from Macro It would certainly be slick to implement a table function that would treat the macro output like an inline view.   select * from table( my_macro( arg1 = 'WHATEVER' ) ); ...
410 Jul 2012 @ 01:21 PDTDatabaseReplyMacro default value   create set table dev_usage_tbl_db.varchar_position( n int not null primary key );   insert into dev_usage_tbl_db.varchar_position select day_of_c...
310 Jul 2012 @ 01:19 PDTDatabaseReplyMacro default value By the way Dieter, I found your string parsing function and am currently using it, so thanks for that as well.   Tom
210 Jul 2012 @ 01:14 PDTDatabaseReplyMacro default value Perfect, thank you.
110 Jul 2012 @ 12:49 PDTDatabaseTopicMacro default value Hello, I've searched in the documentation and on this forum for an answer to my question prior to this post with no luck. I'm coming from an Oracle background, where answers to quest...