Hi,
I am new to database programming, It will be great if somebody will answer
these queries:
Query 1)
Say, I have a table which is having following column
1) STRING 1( string: 12 char max)
2) STRING 2 (string, 12 char max)
3) path( long string)
4) State ( boolean)
5) pupose ( 1 byte)
Assume that I have 1000 records in the table.
My requirement is to search data with below 'SELECT' statement with less
performance issue
My query will be like this:
"SELECT * from database where STRING1 = 'x' && STRING2 = 'y' && STATE = 1
&& purpose = 'z'"
To achive this whether I need to attach given INDEX with the table so that
during INSERT it will be inserted in a sorted order
"Create INDEX INDX on database( STRING1, STRING2, state, purpose)"
i)
If above index is present then the SELECT statement given,
iterates to the all rows present in the table or it directly jumps to the
block where entries satisfying STRING1 = 'x' ??
ii)
Whether INDEXInng based on String( 12 char) gives performace
problem???
iii)
Whether this insertion will be like LINK LIST ( fast) or like
Array(slow)??
iv)
Iis there any other way to call Select statement with less
performance issue?
Query 2)
What will be the performance issue if I create INDEX with PATH( Long text)
in ASC or DSC mode for the above table????
Please revert back.
Thanks and Regards,
PriyaranjanS
-----------------------------------------
*******************************************************************
*** Symbian Software Ltd is a company registered in England and
Wales with registered number 4190020 and registered office at 2-6
Boundary Row, Southwark, London, SE1 8HP, UK. This message is
intended only for use by the named addressee and may contain
privileged and/or confidential information. If you are not the
named addressee you should not disseminate, copy or take any action
in reliance on it. If you have received this message in error
please notify [EMAIL PROTECTED] and delete the message and any
attachments accompanying it immediately. Neither Symbian nor any of
its Affiliates accepts liability for any corruption, interception,
amendment, tampering or viruses occurring to this message in
transit or for any message sent by its employees which is not in
compliance with Symbian corporate policy. *************************
*********************************************
