[SQL] report generation from table.

Hi All, I have been searching for, Preparing report from a huge table. Queries am executing now are, SELECT count(*) from HUGE_TBL where cond1, cond2; SELECT count(*) from HUGE_TBL where cond1, cond3; --- like this i have different conditions(10-15 different things ) and different amount of condi

[SQL] diff b/w varchar(N) & text

Hi., Is there any big difference between selecting the data type as varchar(N) and text. What is the difference of it when seeing from the performance side ? I know that, when we know that the number of character will not exceed N, we can use the varchar as datatype. If we dont know we can use th

Re: [SQL] Exclude fields from SELECT command

In what way it is devil Clarifications. .. > I know better solution. Use only thin tables. Wide tables are devil. :) >