View previous topic :: View next topic
|
Author |
Message |
Manto Jaha
New User
Joined: 26 Jun 2021 Posts: 3 Location: India
|
|
|
|
I know indexes are faster than subscripts, but is there any specific benefit/scenario where I must prefer using Subscript over indexes. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2141 Location: USA
|
|
|
|
Please, give two examples:
1) how do you plan to use indexes?
2) how do you plan to use subscripts?
This is more than enough explanation to your question; it would be very, very easy to find such answer by yourself, in a few seconds.
Indexes vs Subscripts
P.S.
Based on your question I guess that in your specific case it doesnโt make any difference if you used indexes, or subscripts. |
|
Back to top |
|
|
Manto Jaha
New User
Joined: 26 Jun 2021 Posts: 3 Location: India
|
|
|
|
Hi Sergeyken,
All the searches I did only told the differences between Indexes and Subscript. Or else benefits of using indexes as it is faster to access data.
What I am looking for is: What are benefits of using "Subscripts over Indexes".
I just want to know maybe a couple of scenarios where a programmer would prefer using subscript over index.
Ofcourse this is a personal choice of a programmer but knowing indexes are faster why would anyone go for subscript rather than indexes. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3076 Location: NYC,USA
|
|
|
|
Welcome!
Apart from all other differences, here is one you want to consider, You can not pass index via linkage to any other programs while the other does.
Moved to Student Forum. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2141 Location: USA
|
|
|
|
In my previous reference all benefits and drawback are clearly listed, for indexes, and subscripts.
The choice depends 99% on your programโs design, rather than on performance issues. You refused to clarify any details of your case, so no abstract advice can be expected on theoretical โbenefitsโ. |
|
Back to top |
|
|
Manto Jaha
New User
Joined: 26 Jun 2021 Posts: 3 Location: India
|
|
|
|
Thank you Rohit !!! ๐๐ผ๐๐ผ๐๐ผ
@sergeyken: I do not have any "case" for which I could provide details. I am looking for example scenarios where one would prefer using subscript instead of Indexes.
The link you provided or any other site as well only lists definition differences or else benefits of using indexes over subscript while what I was looking for is just opposite of that.
Got 1 example scenario from Rohit !! ๐๐ผ๐๐ผ |
|
Back to top |
|
|
|