Revision 3278
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/py_functions.sql | ||
|---|---|---|
| 235 | 235 |
|
| 236 | 236 |
|
| 237 | 237 |
-- |
| 238 |
-- Name: _namePart_first; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 239 |
-- |
|
| 240 |
|
|
| 241 |
CREATE INDEX "_namePart_first" ON "_namePart" USING btree ((COALESCE(first, '\\N'::text))); |
|
| 242 |
|
|
| 243 |
|
|
| 244 |
-- |
|
| 245 |
-- Name: _namePart_last; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 246 |
-- |
|
| 247 |
|
|
| 248 |
CREATE INDEX "_namePart_last" ON "_namePart" USING btree ((COALESCE(last, '\\N'::text))); |
|
| 249 |
|
|
| 250 |
|
|
| 251 |
-- |
|
| 252 |
-- Name: _namePart_middle; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 253 |
-- |
|
| 254 |
|
|
| 255 |
CREATE INDEX "_namePart_middle" ON "_namePart" USING btree ((COALESCE(middle, '\\N'::text))); |
|
| 256 |
|
|
| 257 |
|
|
| 258 |
-- |
|
| 259 | 238 |
-- Name: _namePart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 260 | 239 |
-- |
| 261 | 240 |
|
Also available in: Unified diff
schemas/py_functions.sql: Removed per-column indexes on relational functions, which are no longer needed by row-based import because it is able to do a merge join-style lookup using the table's UNIQUE INDEX. (Note that column-based import doesn't use the (slower) relational functions at all anymore, and instead calls the corresponding SQL function directly using named arguments.)