Re: NOT NULL

In article <01bc2e85$68e1fc60$1098f5ce_at_default>,   "Minh Giang" <mpg_at_fast.net> wrote:
>
> Hi,
> How much performance degradation to a table with all fields defined with
> NOT NULL compare to a table with one or two fields defined with NOT NULL?
>

In Sybase SQL Server, I don't think there would be a big difference. However, if you put the columns that will most frequently contain null at the end of the table description, your average row length will be shorter, which could result in more rows being stored per page, which would reduce the number of io operations. The gain would depend a lot on row length and the size of the table, etc., and is next to impossible to quantify for anything but a fully defined example.

| Bret Halford                    Imagine my disappointment       __|
| Sybase Technical Support        in learning the true nature  __|
| 6400 S. Fiddlers Green Circle   of rec.humor.oracle...    __|
| Englewood, CO 80111-4954 USA                             |
============================================================

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet