Re: default index type

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 19 Nov 2002 09:47:15 -0000
Message-ID: <3dda08a3$0$8510$ed9e5944@reading.news.pipex.net>

"Peter Erickson" <redlamb_at_redlamb.net> wrote in message news:WRgC9.326$cX3.263791_at_newshog.newsread.com...
> Could anyone please tell me what the default type of index is created when
> using the 'CREATE INDEX...' statement? I am having troubles finding the
> answer for a college class that I am taking. Any help that you could give
> me, I'd really appreciate it. Thanks in advance.
>
> SELECT INDEX movie_yr ON movie(yr);
> Would this create an index using a hash or what?

http://tahiti.oracle.com/pls/tahiti/tahiti.tabbed?section=73943

will give you the answer.

Incidentally when did this tabbed interface appear?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Tue Nov 19 2002 - 03:47:15 CST