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.
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 .

Your Answer:

Login to answer

Other forums

show random images
hey guys

can someone please suggest a way in which the following code can be edited so it onl

Expandable Post Code
Hi,

Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so i

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: [Select]function createthumb($name,$fil

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b

How can you detect variable string in a massive string?
Ok guys, i need some help with this one.

I am going to be getting a large string, like 10-20

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi