s******r
发帖数: 1524 | 1 Never use Teradata before and will touch it now. I know there are some
structure differences between teradata and oracle. Now I am more interested
in for database user, sql, what's the difference between them.
I have a very old sql bible which covers oracle, DB2, sql server but no
teradata.
Any suggestion? Thanks, | c*******e
发帖数: 8624 | 2 mostly performance related
interested
【在 s******r 的大作中提到】
: Never use Teradata before and will touch it now. I know there are some
: structure differences between teradata and oracle. Now I am more interested
: in for database user, sql, what's the difference between them.
: I have a very old sql bible which covers oracle, DB2, sql server but no
: teradata.
: Any suggestion? Thanks,
| s******r
发帖数: 1524 | 3 I know performance is the key. However that's the problem of DBA. As a user,
I hope to have some reference that tell detail of the difference.
For instance, different function, primary index define, commit, volatile,
like(?) table.
I do not want to go through teradata from the very beginning. If find such
book/web, I can focus on the different part. It could save some time.
【在 c*******e 的大作中提到】
: mostly performance related
:
: interested
| B*****g
发帖数: 34098 | 4 http://download.oracle.com/docs/cd/B28359_01/gateways.111/b31050/toc.htm
user,
【在 s******r 的大作中提到】
: I know performance is the key. However that's the problem of DBA. As a user,
: I hope to have some reference that tell detail of the difference.
: For instance, different function, primary index define, commit, volatile,
: like(?) table.
: I do not want to go through teradata from the very beginning. If find such
: book/web, I can focus on the different part. It could save some time.
| s******s
发帖数: 508 | 5 commit is not used often in teradata, assuming warehouse environment.
PI is a key concept. it is used to hash your data in a table.
SQL functions in td are relatively limited. SQL itself is very different
between the two. you need to play with both. stats are imprtant in td and
developers need to know stats.
which version of td, 12 or 13?
【在 s******r 的大作中提到】
: I know performance is the key. However that's the problem of DBA. As a user,
: I hope to have some reference that tell detail of the difference.
: For instance, different function, primary index define, commit, volatile,
: like(?) table.
: I do not want to go through teradata from the very beginning. If find such
: book/web, I can focus on the different part. It could save some time.
| s******r
发帖数: 1524 | 6 Thanks for all your help.
From the document I read, without commit, no result would be saved, commit
is necessary for my system. Sounds it is only setting of our teradata? You
are right, stats is also important.
I realized the difference and hope to get a comparison book/web.
Our system is 13.
【在 s******s 的大作中提到】
: commit is not used often in teradata, assuming warehouse environment.
: PI is a key concept. it is used to hash your data in a table.
: SQL functions in td are relatively limited. SQL itself is very different
: between the two. you need to play with both. stats are imprtant in td and
: developers need to know stats.
: which version of td, 12 or 13?
| w*r
发帖数: 2421 | 7 Teradat 13??? yoru company is brave!!!!!
commit
You
【在 s******r 的大作中提到】
: Thanks for all your help.
: From the document I read, without commit, no result would be saved, commit
: is necessary for my system. Sounds it is only setting of our teradata? You
: are right, stats is also important.
: I realized the difference and hope to get a comparison book/web.
: Our system is 13.
|
|
