2,869 reputation
2921
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 4 months
seen 1 hour ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


1h
comment Can I trigger events based on timestamp data or should I use polling?
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.
22h
comment PostgreSQL Role Configuration
Link-only answers are discouraged. Please include the gist of the document here.
Nov
20
comment Bulk Delete for Large Table in MySQL
And this won't affect new data being inserted/updated? I don't think so.
Nov
19
comment Setting up a centrally based server repository (database)
Great! Can you edit your question to include this information? Then delete the comment.
Nov
19
comment Setting up a centrally based server repository (database)
This is very vague. What will this database be used for? Just information, or will the "database" also need to "do things"? How do you envisage "the database" being accessed?
Nov
19
comment ORDER BY using custom priorities for text columns
Note that a) the brackets are optional: a case expression (as this is called) is valid anywhere a column can be specified; and b) the expression can be slightly simplified to case `cat` when 'mgr' then 1 when 'dev' then 2 else 3 end
Nov
18
comment count of values in a multivalue field
A where clause containing an aggregate function is almost certainly an error. Try using having instead.
Nov
18
comment After upgrade from 9.1 to 9.3, commands still point to 9.1
Why not uninstall the 9.1 versions?
Nov
14
comment Restoring master database
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.
Nov
10
comment Using triggers or php code
I'd say neither. It's a derived value.
Nov
5
comment Bulk insert into SQL Server from VMWare guest using distributed switch
Which IPS device? How does your environment compare to that of the asker and how will it solve his problem?
Nov
3
comment Equality in JOIN or WHERE clause? Efficiency and style
In your first query, the brackets aren't necessary, so I'd remove those. I prefer the first style, but it's just a preference.
Oct
30
comment Slow index scans in large table (PostgreSQL 9.2)
A partial index is one created with a where clause: it needs to match exactly the where clause being used in the query for the index to be considered. The classic use case for this is an index on a status column in a queue-like table where only a few records are active.
Oct
30
comment Slow index scans in large table (PostgreSQL 9.2)
Finally: if you are often querying only for one particular value of prop, you could create a partial index. But I suspect this is a generic query.
Oct
30
comment Slow index scans in large table (PostgreSQL 9.2)
How many percent of the table does your date range represent (without taking into consideration the values for prop)? If just a small percentage, maybe an index on ("timestamp", prop) would be better. Multiple indexes with the same leading column(s) (prop in your case) is also often redundant.
Oct
30
comment Slow index scans in large table (PostgreSQL 9.2)
Strange: Your explain analyze shows prop_time_idx, yet the table definition shows entry_prop_id_timestamp_idx. Is this the same index? Please fix.
Oct
30
comment Slow index scans in large table (PostgreSQL 9.2)
Please tell us what your table looks like, what indexes it has and the spread of data.
Oct
20
comment how to order a field based on two parts of the row value
What do you have so far?
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
Why do you want to do this?
Oct
17
comment Performance first low, then high after adding index, then keep high after drop index
Which DBMS are you talking about?