Indexing tables [message #237730] |
Tue, 15 May 2007 09:41 |
matpj
Messages: 115 Registered: March 2006 Location: London, UK
|
Senior Member |
|
|
HI all,
I have a very basic knowledge of SQL, and have created a table in an Oracle database using the following script:
CREATE TABLE NIKU.DSTI_RES_OBS_HISTORY
(
PRID NUMBER(10) NULL,
PRSTART DATE NULL,
UNIQUE_NAME VARCHAR2(96) NULL,
FULL_NAME VARCHAR2(300) NULL,
ID NUMBER(10) NULL,
PARENT_OBS VARCHAR2(96) NULL,
OBS_UNIT_ID NUMBER(10) NULL,
NAME VARCHAR2(96) NULL
)
I am populating this table with a third party data transfer tool, which runs some SQL on a selection of tables in the same tables, and apends each time it is run (to build a history)
I have no idea about indexes so wasn;t sure if I need to index the table, and if so how?
any advise will be appreciated.
Many thanks,
Matt
|
|
|
|
Re: Indexing tables [message #237735 is a reply to message #237733] |
Tue, 15 May 2007 09:51 |
matpj
Messages: 115 Registered: March 2006 Location: London, UK
|
Senior Member |
|
|
I dont suppose you can elaborate on that please?
why dont I need to index?
what benefit does indexing give?
trying to learn but cant find the answer in the Search function.
Thanks,
Matt
|
|
|
|