#DateWhereItemComment
516 Nov 2011 @ 01:17 PSTDatabaseIndexes, Too Much of a Good Thing?If you are looking for a great reference on Teradata Indexes, I have just the book for you! "Teradata┬« Database Index Essentials" is available at: http://TeradataIndexes.com
422 Aug 2011 @ 12:34 PDTDatabaseIndexes, Too Much of a Good Thing?There is no difference in a table that is created in a database vs. a user.
322 Aug 2011 @ 12:33 PDTDatabaseIndexes, Too Much of a Good Thing?The Optimizer will do a Full Table Scan if it is not supplied with the 'complete' index value. That is to say, it is looking for a value it can hash. If you are using a Seconday Index, the Optimi...
222 Aug 2011 @ 12:16 PDTDatabaseIndexes, Too Much of a Good Thing?Multi-Table Join Indexes and Single Table Join Indexes are database objects. They are different than secondary indexes which are actually subtables that automatically refer back to the base table ...
120 May 2009 @ 10:10 PDTDatabaseIndexes, Too Much of a Good Thing?Celia, That's a great question. In TD 13 there is an option to create tables with no primary index. On this one, we broke all the rules, and the developers had a lot of fun doing it! As you kn...