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

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Reg Ex
Im trying to search for the string: srv_9 (Dead ???)

I thought to use preg_match, however I d

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

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