Home » SQL & PL/SQL » SQL & PL/SQL » question on index
question on index [message #2887] Mon, 19 August 2002 16:51 Go to next message
JAM
Messages: 3
Registered: August 2002
Junior Member
COuld be a simple question...?
I guess the index is not only helpful during select statements but also during update and delete except the insert statment. Am I correct?

Report message to a moderator

Re: question on index [message #2894 is a reply to message #2887] Tue, 20 August 2002 04:36 Go to previous messageGo to next message
Abul Fazal
Messages: 39
Registered: February 2002
Member
No During 'UPDATE' & 'DELETE' the data in the Index has also to be modified along with the data in the Base table. Even during 'SELECT' process, many a criteria have to be satisfied to use the different type of Indexes.

Report message to a moderator

Re: question on index [message #2900 is a reply to message #2887] Tue, 20 August 2002 09:30 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Yes, an index can also be used during UPDATE and DELETE statements to efficiently locate the row(s) being modified.

Report message to a moderator

Previous Topic: Diff. Procedure & Stored Procedure ?
Next Topic: DATE FUNCTION
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 12:51:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.