At max how many columns is advisable to create in a table/view


Posted on 16th Feb 2014 07:03 pm by admin

Hi All,
I have two transaction table from which i want to create a simple view or materialized view. But the number of columns is about 200. So i want to know at max how many columns is advisable from the performance point of view.

Even though i will create 200 columns in a view , for a perticular client installation i may not use all the columns.
Did you know?Explore Trending and Topic pages for more stories like this.
one more thing i will never use 200 columns in the select statement . At a time i will use only 4/5 columns.

It may happen from this four column one column will be the 1st and 2nd column will be the 200th one.

I want to know how it affects the performance and in which scenario . Please help if any body knows or already faced this kind of scenario.
I am using oracle 10g .
No comments posted yet

Your Answer:

Login to answer
301 Like 29 Dislike
Previous forums Next forums
Other forums

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

PHP error (line 38) my website
Hello everyone, I'm new on this
and I got a web site thats got a error not showing the photos on<

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and

ScriptManager History and Opera Issue
I am having an issue in opera with the ScriptManager. I have a ScriptManager on a page with history

IS Retail & Manufacturing
Hi

Can IS Retail and Manufacturing activities be done in same instance ie. in same client

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash