Hi, I have a few easy questions for any Oracle Gurus out there:
- Does the data type PLS_INTEGER use four bytes to store a value (it's
possible ranges in value are -+ 2 Gigabytes, which is the same as a
signed integer in a 32 bit programming environment)?
- If you declare a column with a data type of NUMBER(10), are there
only ten bytes taken for storage, or is it still 22 bytes? Conversely,
declaring the same column as VARCHAR2(10) is it or is it not more
efficient than numeric? (In the case of using the column as a primary
key).
- Does anybody have any concrete proof (or know where I could find
some) that would substantiate (or disprove) this statement: "Oracle
processes faster when all primary keys are integer data types as
opposed to variable character columns."
- I would really appreciate any recommendations for good reading
materials on performance tuning Oracle.
If you could be so kind as to post replies to the newsgroup, as well as
forwarding to this email: mike_kares_at_pre-print.com (please change the
underscore to a period), I would be in your debt!
Thanks!
Mike Kares
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Wed May 19 1999 - 13:34:59 CDT