2,850 reputation
2921
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 3 months
seen 9 hours ago

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


12h
reviewed No Action Needed Last synchronization time between master and slave (replication)
16h
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.
17h
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.
17h
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.
17h
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.
18h
revised Is Moving data from Greenplum to Oracle for reporting is advisable?
edited tags
18h
revised Using Cloud Oracle server in .Net application (ASP.Net web site)
edited tags
18h
reviewed Looks OK How to List out all the tables on the SQL server which do not have a Clustered index?
18h
reviewed Looks OK Work with table named Group
18h
reviewed Looks OK Calculate number of items with distinction using SQL
18h
reviewed Reviewed Slow index scans in large table (PostgreSQL 9.2)
18h
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.
18h
reviewed Approve suggested edit on Query perfomance with multiple JOINs on MyISAM-based DB
18h
reviewed Approve suggested edit on Cancel Query in remote ssms from ssms in my pc
1d
reviewed No Action Needed Improve processing of data and structure design from flat file to CMS DB (using intermediate DB)
1d
reviewed No Action Needed Where to put my.ini file for 5.6.21 MySQL Community Server on Windows
1d
revised Char in select why
added 2 characters in body; edited tags
2d
reviewed Looks OK Altering table Foreign Keys produces an error (errno:150) (MySQL)
2d
reviewed Approve suggested edit on SQL Server suspect database?
2d
reviewed No Action Needed ISO Week vs SQL Server Week