Home » SQL & PL/SQL » SQL & PL/SQL » Indexing tables
Indexing tables [message #237730] Tue, 15 May 2007 09:41 Go to next message
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 #237733 is a reply to message #237730] Tue, 15 May 2007 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>I have no idea about indexes so wasn;t sure if I need to index the table,
If you have to ask this question, then then answer is "NO need to index table".
Re: Indexing tables [message #237735 is a reply to message #237733] Tue, 15 May 2007 09:51 Go to previous messageGo to next message
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
Re: Indexing tables [message #237736 is a reply to message #237730] Tue, 15 May 2007 09:53 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
visit http://tahiti.oracle.com & Read The Fine Concepts Manual.
Previous Topic: Explain Plan
Next Topic: Design Question
Goto Forum:
  


Current Time: Wed Dec 07 02:41:42 CST 2016

Total time taken to generate the page: 0.08354 seconds