Reputation
20,000
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
4 37 71
Newest
 index
Impact
~1.5m people reached

Mar
30
comment Display two digits after decimal point in SQL from average value
Added mysql tag based on the usage of those backticks
Mar
30
comment Pooling at the app layer or in an intermediate layer?
If you have a Java application anyway, I'd go with a JDBC connection pool in your app server. The app server needs to be configured anyway, and thus you don't need another system that needs to be configured and setup.
Mar
30
comment To partition or not to partition?
I agree with dizzystar, I wouldn't bother right now. Cross that bridge if you reach it. Currently partitioning in Postgres also makes it hard (if not impossible) to use proper foreign keys (this might change with 9.7 but nothing is settled yet). Even a table with 50M rows is not necessarily a candidate for partitioning. If you mainly have equality conditions in your queries that reduce the number of rows substantially, good indexing can get you a long way.
Mar
30
comment How to give title to the result of a select query in postgresql?
This depends on the SQL client you are using.
Mar
30
comment Oracle : Is my DISTINCT function working properly?
distinct is not a function. But yes, the distinct operator works correctly on for alphanumeric values. Your two queries are not counting the same things
Mar
29
comment Aggregate sampler function for programmer express predictions
I wonder if TABLESAMPLE is what you are looking for: postgresql.org/docs/current/static/sql-select.html and postgresql.org/docs/current/static/tsm-system-rows.html
Mar
29
comment Why would Vertica let me start a transaction if I can't roll it back?
If the driver doesn't support that, it has to be the client ;) But why don't you simply turn off autocommit in DBeaver completely? Then you don't need to worry about begin transaction at all. You just need to make sure you commit properly.
Mar
29
comment Why would Vertica let me start a transaction if I can't roll it back?
Well, the client needs to disable auto-commit once you start a manual transaction.
Mar
29
comment Why would Vertica let me start a transaction if I can't roll it back?
Which tool are you using to run this? Maybe that doesn't properly support the begin transaction thing.
Mar
29
comment which way is better to design shopping Cart Table - SQL Server
Definitely solution 2. Solution 1 violates 1NF.
Mar
29
comment Oracle 11G, Move indexes from one datafile to another
You can't move data between data files only between tablespaces.
Mar
27
comment could not allocate a new page for database
Which DBMS are you talking about?
Mar
26
comment How to store schema-less data efficiently in a relational database?
Postgres has a lot more NoSQL features than MySQL. The JSON implementation is much more efficient (you can index JSON documents) and it has a very efficient key/value store (also indexable). Postgres is probably the most advanced "NoSQL relational database".
Mar
26
comment Poor Query performance in postgresql 9.3
You query only takes 1.3 seconds according to the explain analyze. The 2 minutes you are seeing are most probably caused by your SQL client to display over 5 million rows.
Mar
24
comment How to make Database to support Multiple Languages
NCHAR is a bad suggestions due to the padding that is applied to those columns. NVARCHAR would be a much better choice
Mar
22
comment Poor Query performance in postgresql 9.3
Please edit your question and add the execution plan using explain (analyze, verbose)
Mar
22
comment Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?
Please read my question: I have stated that I can fined Logons Per Sec in DBA_HIST_SYSMETRIC_HISTORY. But I am looking for User Logon Time
Mar
22
comment How to convert varchar2 column to number in oracle?
But the (useless) comparison is the reason for your error message
Mar
22
comment How to convert varchar2 column to number in oracle?
That is a different question. And I still don't understand why you are comparing those two values in your where clause
Mar
22
comment How to convert varchar2 column to number in oracle?
I understand that, but still comparing the column emp_salary to the number does not make any sense