Posted by DickChristoph on 03/26/07 02:56

Hi

> Is it wise to use a view to insert the record.
> Is there any performance issue may come due to this view.
> I would like to know the opinion on this?

Well you can set up partitioned Views when the view is the Union of many
tables. The tables can then be stored on multiple physical drives. and the
partioning takes care of putting the data in the right table based on the
partioning column.

-Dick Christoph


<plmanikandan@gmail.com> wrote in message
news:1174508793.879342.208410@e65g2000hsc.googlegroups.com...
> On Mar 21, 7:45 pm, "Jack Vamvas" <DEL_TO_RE...@del.com> wrote:
>> Sounds like a View
>>
>> --
>>
>> Jack Vamvas
>> ___________________________________
>> Advertise your IT vacancies for free at -http://www.ITjobfeed.com
>>
>> <plmanikan...@gmail.com> wrote in message
>>
>> news:1174495141.918629.74950@d57g2000hsg.googlegroups.com...
>>
>> > Hi,
>> > I would like to know details about the table name starts with prefix
>> > in sql server 2000.
>> > Actually i'm working on existing code.
>> > The existing code insert a record into a table, but the table name in
>> > the code and table name in database are different
>> > Table name in database : tbl_mmm_ox
>> > In coding they are using table name as mmm only, the records are
>> > properly inserted into mmm table
>> > is it possible?
>> > The sample code is like that(using ado object)
>> > oCmd.CommandText = "INSERT INTO mmm (no,name) values (1,"mm")"
>> > The above code is perfectly working and inserting record into
>> > tbl_mmm_ox.
>> > Could anybody explain how is it possible?
>> > whether we can leave the prefix(tbl) and suffix(ox) and sql server
>> > take care of this?
>>
>> > Thanks & Regards,
>> > Mani
>
> Thanks friends.It's view only.find that view after posting this
> message.
> Is it wise to use a view to insert the record.
> Is there any performance issue may come due to this view.
> I would like to know the opinion on this?
>
> Thanks & Regards,
> Mani
>
>
>

[Back to original message]