Class Phalcon\Db\Index

implements Phalcon\Db\IndexInterface

Source on GitHub

Allows to define indexes to be used on tables. Indexes are a common way to enhance database performance. An index allows the database server to find and retrieve specific rows much faster than it could do without an index

  1. <?php
  3. // Define new unique index
  4. $index_unique = new \Phalcon\Db\Index(
  5.     'column_UNIQUE',
  6.     [
  7.         'column',
  8.         'column'
  9.     ],
  10.     'UNIQUE'
  11. );
  13. // Define new primary index
  14. $index_primary = new \Phalcon\Db\Index(
  15.     'PRIMARY',
  16.     [
  17.         'column'
  18.     ]
  19. );
  21. // Add index to existing table
  22. $connection->addIndex("robots", null, $index_unique);
  23. $connection->addIndex("robots", null, $index_primary);

Methods

public getName ()

Index name

public getColumns ()

Index columns

public getType ()

Index type

public __construct (mixed $name, array $columns, [mixed $type])

Phalcon\Db\Index constructor

public static __set_state (array $data)

Restore a Phalcon\Db\Index object from export