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

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

why is it over writing
Code: $filepaths[] = $_FILES['new_image'];
foreach ($filepaths as $filepath)
{
$imagename =

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Sufficient protection from bad input?
I am writing a simple script to let people upload 'pages' of their own content, be it simply a few b