#DateForumTypeThreadPost
29110 Apr 2012 @ 04:32 PDTDatabaseReplyQUALIFY ... OVER (PARTITION BY ...) phrase And some extracts from the documantation The ANSI SQL:2008 window feature provides a way to dynamically define a subset of data, or window, in an ordered relational database table. A windo...
29010 Apr 2012 @ 03:38 PDTDatabaseReplyQUALIFY ... OVER (PARTITION BY ...) phrase You have a query and you have questions to the syntax. Why don't you try yourself? The OVER is part of the OLAP functions syntax as the SET in an UPDATE. QUALIFY will limit the resul...
28906 Apr 2012 @ 10:36 PDTDatabaseReplyPerformance on a table with 200 Million Records no difference from the db perspective - as long as the view is not having business logic implemented. But if the view has some conditions or joins etc. the top would only be applied after al...
28806 Apr 2012 @ 12:35 PDTDatabaseReplyPerformance on a table with 200 Million Records Do you do a plain Select top 10 * from table; ? Or do you apply filter, joins? If it is a plain select * from table you might face TASM delays or the table is not a table...
28705 Apr 2012 @ 01:06 PDTDatabaseReplyhow to write a function to retrieve random character from A TO Z select top 10 substr('LBXIDZDEEDNRKRUEBHMGZTHDIWMUWGNPLUJOUELEENNISWQEHREUWYBIDGDNQLRYYYQTHNOTPUDXXOCSDWJHGAWFKKHEJLFPOGBALFSXOCHOJPCTNBINWRDQRRINKGRSPQESSQXRFWUTCZGLESYCJOCGZGYAQDEOVGIIPR...
28605 Apr 2012 @ 12:50 PDTDatabaseReplyPerformance on a table with 200 Million Records Did you try select top 200 * from table?
28505 Apr 2012 @ 12:47 PDTDatabaseReplyPerformance on a table with 200 Million Records yes - but what do you want with 200 mio rows in a select *?
28405 Apr 2012 @ 10:27 PDTDatabaseReplyPerformance on a table with 200 Million Records not unique is not an issue as long as skeq is not too high. Don't forget a PI has two purposes! 1. Access and 2. distribution. if skeq is not too high and you need a unique constrain...
28304 Apr 2012 @ 11:18 PDTToolsReplyFastload error : Not enough fields in vartext data record can you please share the fastexport and fastload script. you need to allign the export mode and format.  
28204 Apr 2012 @ 09:54 PDTDatabaseReplyValue ordered secondary index vs Partitioned primary index How selective is your condition Txn_dt between Period_start_date & period_end_date? E.g. what is the % of rows retrieved by this condition?
28104 Apr 2012 @ 09:53 PDTDatabaseReplyPerformance on a table with 200 Million Records did you consider to use a PI of (y,z)? Can you run select top 100 hashrow(y,z), count(*) from your_tab group by 1 order by 2 desc and share the result?
28003 Apr 2012 @ 11:42 PDTDatabaseReplyQUALIFY ... OVER (PARTITION BY ...) phrase Hi, Qualify filters on OLAP functions - simmilar to having clause in aggregate functions. over and partition are both part of the row_number() function check  http://www.goo...
27903 Apr 2012 @ 07:47 PDTDatabaseReplyrecursive way ¿? But in an relational DB you do not have an order within the table. 
27803 Apr 2012 @ 05:07 PDTDatabaseReplyrecursive way ¿? Yes, recursive query should do. check the forum, there exists different examples. But how do you link son-1 to father-1 and father-3 but not to father-2? I think your base table is missi...
27703 Apr 2012 @ 12:07 PDTDatabaseReplySql query help this migh do without union  select product, substr(val,16) as category, cast(substr(val,5,11) as integer) as xvalue from ( select product, max(case when category ...
27602 Apr 2012 @ 10:23 PDTDatabaseReplyMultiSET and SET please don't get it personal but these are very basic questions addressing different areas. Start using Google (the site internal seach is suboptiomal ;->) and search for the terms pl...
27502 Apr 2012 @ 12:30 PDTDatabaseReplyValue ordered secondary index vs Partitioned primary index   There are different dimensions to consider 1. value ordered NUSI requires additional space and maintenance 2. value ordered NUSI will only be used for selective conditions ...
27401 Apr 2012 @ 11:55 PDTPrivate Forum
27330 Mar 2012 @ 08:51 PDTDatabaseReplyOLAP functions   yes concat the rowid in from and do a substr afterwards   something like   cast(substr(min(rowid !! duration) ,xx) as integer)   ...
27230 Mar 2012 @ 01:35 PDTDatabaseReplyteradata sql return string to blank column can you share a picture of the screen with the query and the result set? You can attached files to posts...
27129 Mar 2012 @ 08:13 PDTDatabaseReplyCount by two different columns without using full outer join How about  sel cal_table.month as mnth, sum(case when extract(month from created_date = cal_table.month then 1 else 0 end), sum(case when extract(month from closed_date = ca...
27029 Mar 2012 @ 12:35 PDTDatabaseReplyTransform rows to one column string check recurive queries http://forums.teradata.com/forum/database/string-concat-returning-multiple-rows-in-one-string-cocat-row might give you an idea
26927 Mar 2012 @ 05:10 PDTDatabaseReplyOrder of joins in the SQL @reddygn1 What is your question? Can you give examples? And maybe open a different thread...
26826 Mar 2012 @ 08:44 PDTGeneralReplySQL for the current month begin date and end date Select (current_date - extract(day from current_date))+1 , add_months(current_date,1) - extract(day from add_months(current_date,1))  Ulrich
26726 Mar 2012 @ 01:36 PDTDatabaseReplyPerformance question Sorry no - you should go for an explicit conversion with the cast as this is documenting what you want to do - at least as long as you can't prove that the implicit conversion is significant...

Pages