Project

General

Profile

Actions

Task #456

open

test that querying the DB uses the unique indexes instead of a seq scan

Added by Aaron Marcuse-Kubitza over 11 years ago.

Status:
New
Priority:
Normal
Start date:
07/30/2012
Due date:
% Done:

0%

Estimated time:
Activity type:

Description

Sample query:

select * from "public.<date>".specimenreplicate
where
datasource_id = 1
and COALESCE(institution_id, 2147483647) = 1
and COALESCE(collectioncode_dwc, '\\N'::text) = ''
and COALESCE(catalognumber_dwc, '\\N'::text) = ''

No data to display

Actions

Also available in: Atom PDF