INDEXING

[juliahutapea]

tanya donk teman...

gw baca ada thread sebelumnya yang ngebahas ttg indexing juga..
tapi mash kurang ngeh...
indexing itu kita lakukan di salah satu kolom di database khan?
nahh..rata2 khan uda ada fungsi indexingnya dari sql servernya

klo mau buat indexing manual gmn ya?

ty

[morpheus]

index dibikin supaya mencari jadi lebih cepat. kalo tidak ada index, db akan mencari secara linier, yg akan memakan waktu lebih lama.

[johan3000]

As mentioned in the Index overview page, a table index helps SQL statements run faster. The syntax for creating an index is:

CREATE INDEX "INDEX_NAME" ON "TABLE_NAME" (COLUMN_NAME)

Let's assume that we have the following table,

TABLE Customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)


and we want to create an index on the column Last_Name, we would type in,

CREATE INDEX IDX_CUSTOMER_LAST_NAME
on CUSTOMER (Last_Name)

If we want to create an index on both City and Country, we would type in,

CREATE INDEX IDX_CUSTOMER_LOCATION
on CUSTOMER (City, Country)

[Sunkmanitu Tanka Ob'waci]

patokannya kita buat index untuk kolom yang sering diakses dan foreign key.