473,321 Members | 1,667 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Obese Table

I need to create a table which will have about 17 columns, most of
them text. No column will be large enough to require a CLOB, but
together the potential row size will be more than 32K.

Windows Server 2003, DB2 V8.1.5.449, WSE.

Is there any way to do this in a single table?

SS
Nov 12 '05 #1
2 1508
Can you classify the columns into logical groups that are used together?
One way would be to split the table vertically and place a view on top.
An instead of trigger can handle update/delete/insert.
If you only access one side of the table at a time DB2 figure out that
one it can safe the join, given e.g. some RI.

Cheers
Serge
Nov 12 '05 #2
Thanks, Serge.

When you say "split the table vertically ," I'm assuming what my mind
says is horizontally. Ie, change
CREATE TABLE MYTABLE (
User_ID ...
Time_started ...
Time_Ended ....
Time_Signed ....
TextField1 ...
Textfield2 ...
. . .
TextFieldn ...

change it into
CREATE TABLE MYTABLE1 (
User_ID ...
Time_started ...
Time_Ended ....
Time_Signed ....
TextField1 ...
Textfield2 ...

and

CREATE TABLE MYTABLE2 (
User_ID ....
TextField3 ....
. . . .
TextFieldn

Then create a view that joins the two tables and expose only that view
to the user. As it happens, this view (tables) will very rarely have
deletes and never have updates (deletes will be done in batches and
run overnight). It will have inserts often.

Is an "instead of" trigger still desirable, would it allow inserts
more efficiently if only MYTABLE1 were needed? Would it avoid a null
entry into MYTABLE2 if that were not used?

When you say, "DB2 [can] figure out that ... it can save the join,
given e.g. some RI." -- Like what or how much RI? Every field?
Which fields?

SS

Serge Rielau <sr*****@ca.eye-bee-em.com> wrote in message news:<7d*********************@news01.bloor.is.net. cable.rogers.com>...
Can you classify the columns into logical groups that are used together?
One way would be to split the table vertically and place a view on top.
An instead of trigger can handle update/delete/insert.
If you only access one side of the table at a time DB2 figure out that
one it can safe the join, given e.g. some RI.

Cheers
Serge

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Xah Lee | last post by:
Here's the belated Java solution. import java.util.List; import java.util.ArrayList; import java.lang.Math; class math { public static List range(double n) { return range(1,n,1); }
5
by: Jim Garrison | last post by:
Scenario: 1) Create a GLOBAL TEMPORARY table and populate it with one (1) row. 2) Join that table to another with about 1 million rows. The join condition selects a few hundred rows. ...
4
by: Gaz | last post by:
Hi, I need to have a table nested within another table. The tables are alongside each other visually speaking, and the nested table (on the right) can vary in size. My problem is that when the...
10
by: John | last post by:
I have a table with two rows. On the first row is a text box and in the second row is an image. I have set the table cellpadding to 0 and cellspacing to 0. The table is leaving extra spaces in the...
3
by: Max Power | last post by:
HTML reprocessor: how do you get rid of bloated (obese) MS-Word (normal or filtered) HTML? I just want all the fancy MS tags removed and replaced with basic ones, or if applicable -- stripped...
1
by: Max Power | last post by:
HTML reprocessor: how do you get rid of the obese MS-Word (normal or filtered) HTML? I just want all the fancy MS tags removed and replaced with basic ones, or if applicable -- stripped entirely...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
5
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.