title: using index tablespace?
body: <p>I came across two code snippets :</p>
  
  <p>one...</p>
  
  <blockquote>
    <p>ALTER TABLE table_name<br>
    DROP CONSTRAINT constraint_name;<br>
        DROP INDEX index_name;<br>
       alter TABLE table_name  ADD CONSTRAINT constraint_name PRIMARY KEY (column, column)<br>
    <strong>USING INDEX TABLESPACE tablespace_name</strong>;</p>
  </blockquote>
  
  <p>Two ...</p>
  
  <blockquote>
    <p>CREATE INDEX index_name ON table_name (column_name)<br>
    <strong>TABLESPACE tablespace_name;</strong></p>
  </blockquote>
  
  <p>Now I can understand the statements that are not in bold but the statements in bold are quite difficult to understand. Why are we using tablespaces, especially in this context? What is the meaning of these two statements? Can someone give me a detailed answer with examples?<br>
  Thank you!</p>