154
edits
Changes
Jump to navigation
Jump to search
Patent Data Processing - SQL Steps (view source)
Revision as of 16:39, 23 June 2016
, 16:39, 23 June 2016→Patents
==== INDEX CREATION ====
Patent numbers are distinct in this table, and are central to the rest of the fields in the table. A primary key can therefore be imposed on the column. Also, since a number of searches are likely to be conducted on this table, an index has been imposed as well.
Code: ALTER TABLE patents ADD PRIMARY KEY (patentnumber); -- RESULT : ALTER TABLE allpatent=# CREATE UNIQUE INDEX patent_idx ON patents (patentnumber);
Since the table is relatively large, and is likely to be searched often, an index has been imposed on the table. allpatent=# CREATE INDEX ON assignees (orgname); CREATE INDEX
Patentdata:
