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

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_
Can anyone view my code and tell me why im getting the error:
Parse error: syntax error, unexpect

cURL proxy
Okay here is the thing... i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

Character Sets/Collations Stuff
Can someone please give me a check list of things I must do to setup all the charset stuff for my ph

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists