Re: Can I have an explicit cusor like this?

C Chang <cschang_at_maxinter.net> writes:

> I totally agree with your suggestion that there should be one table.
> However, the person who created the table(s) prefers to keep the all
> data in mutliple tables. Of Course, I will try my best to convince him
> (he has own reason). Or I am thinking of creating a view that combines
> all tables such as
> CREATE a_view
> select col1, col2
> from table1
> PLUS
> select col1, col2
> FROM table2
> ..;
> I never used such kind of PLUS ( horizontal combination of tables)
> I am not sure it will works, I will try later. Thanks.
>
> C Chang

Eeeek! Its bad enough having the same type of data in multiple tables - but then trying to re-combine them in a view makes me shiver!

I have seen this sort of thing done before to "improve performance" by moving "old" data to identical tables with names like blah_old, blah_very_old etc (actually, the names of the tables were stick, bigStick, veryBigStick and log - I'm serious!). In may experience its always caused problems at some point and if the person who is trying to do this is using a similar rationale, then I'd suggest you tell them about partitions.

Tim Received on Mon Jun 24 2002 - 18:27:23 CDT