Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How DB2 searches LDS without indexes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
nandini

New User


Joined: 27 Feb 2004
Posts: 18

PostPosted: Wed Jul 14, 2004 7:56 am    Post subject: How DB2 searches LDS without indexes
Reply with quote

Hi

LDS has no index.But in db2 we are using only lds.Then in db2 how searching is possible with index



Nandini
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Thu Jul 15, 2004 11:37 pm    Post subject: Re
Reply with quote

DB2 uses sequential search
Back to top
View user's profile Send private message
Rams

New User


Joined: 17 Apr 2005
Posts: 1

PostPosted: Sun Apr 17, 2005 12:29 pm    Post subject: Re: LDS
Reply with quote

LDS uses Hashing searching techniques
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 XML indexes (V10) ozburt DB2 2 Tue Jan 07, 2014 3:39 pm
No new posts How to access SYSCAT.INDEXES ravikumar15 DB2 6 Thu Apr 25, 2013 1:08 am
No new posts Performance by DB2 with non-unique in... rakesh1155 DB2 10 Wed Mar 14, 2012 12:58 pm
No new posts Why Alternate indexes are not support... Phrzby Phil Mainframe Interview Questions 18 Mon Nov 28, 2011 12:19 pm
No new posts need some info on DB2 indexes raja1128 DB2 3 Sat Jul 30, 2011 6:25 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us