Re: optimum datatype for primary key column O9i

> How can anyone give such a rude and incompetent answer to a sensible
> question?
>
> Nobody claimed that leading zeroes can be stored in a number datatype.
>
> The question is:
> Does declaring a column as number(10,0) make it need less memory
> storage than declaring it simply as number?
>
> Are search operations which use the index faster when the index column
> is declared as number(10,0) as compared to when it is declared as
> number? [...<added>or as any other type whatsoever given you are using
> only digits for values]
> regards,
> Max

Max you have summarised to the exact question which I was trying to pose
all along, I have just added the note in [...] for further clarification

Of the above, the second issue on joins is vital specially as there are large tables and large joins. A typical SQL for a complex report in a substantially normalised database can be a nightmare and every bit of optimisation helps (sometimes we have over 10 joins and at least 2-3 tables have over 1,000,000 rows, while other hover around 100,000 rows). In fact that is where we use Oracle

Space is not the issue, only its implication in speed is, Infact all focus is on optimisation in SQL for Selects with large joins, rows sets
and possible group by clauses

In response to the observations in the other posts, i would like to state that I have been thru the manuals but the could not find sufficient material to the issues as summarised above, specially the second.

I suppose "Senior Oracle DBA's" have a right to be ... Received on Thu Oct 30 2003 - 13:22:55 CET