#DateForumTypeThreadPost
612 Aug 2009 @ 05:57 PDTDatabaseTopicIDENTITY COLUMN - 5753 error messageHi, i was surprised to get an error message (5753 Numbering for Identity Column %VSTR is over its limit) when inserting a new row from a SQLA session (ODBC) or BTEQ session, while i could insert r...
523 Jul 2009 @ 07:00 PDTGeneralReplySuggestion for a new Forum?@Lucky Sorry, i have no experience in RFID, but a lot of interest since i work in retail business ...
422 Jul 2009 @ 06:24 PDTGeneralReplySuggestion for a new Forum?I suggest to give some place to RFID issues and projects. A quick search across the Teradata forums gave nothing...
321 Jul 2009 @ 12:28 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)Hi Dieter, yes it is a plain "SELECT TOP 10 * FROM table;" i didn't mentionned that PI of "Table_1" is a 5 columns index (skewfact=0), when PI for "Table_2" is a 2 columns index. But this not a c...
220 Jul 2009 @ 08:12 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)Well, i can report hereafter the comparison between "table_1" and "table_2" : select TOP 10 * on the biggest one ("table_2) returns 10 rows in 1 second ! Statistics are collected and up to date...
117 Jul 2009 @ 05:29 PDTDatabaseTopicSELECT TOP N - odd behaviour (v2r6)Hello, "SELECT TOP n from table" can be very fast, even on large tables, and is showing an odd behaviour on other tables, with a three steps explain .. to get 10 records in one minute ! Ho...

Pages