 | |
#1
 
| |||
| |||
|
How index table keeps index records -
02-19-2008
, 03:32 AM
#2
| |||
| |||
|
|
I have a table with following columns: division * group * email Then, i create a non-unique index for: division * group I insert the following data: division * group * email 1 * * * * * *A * * * * a... (AT) hotmail (DOT) com 1 * * * * * *A * * * * b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division * group 1 * * * * * *A or will it contains 2 index records, i.e. division * group 1 * * * * * *A 1 * * * * * *A Thanks for prompt reply. |
answer directly.
But I do have to ask: Why do you care? What business need will this
knowledge serve?
Ed
#3
| |||
| |||
|
|
I have a table with following columns: division * group * email Then, i create a non-unique index for: division * group I insert the following data: division * group * email 1 * * * * * *A * * * * a... (AT) hotmail (DOT) com 1 * * * * * *A * * * * b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division * group 1 * * * * * *A or will it contains 2 index records, i.e. division * group 1 * * * * * *A 1 * * * * * *A Thanks for prompt reply. |
answer directly.
But I do have to ask: Why do you care? What business need will this
knowledge serve?
Ed
#4
| |||
| |||
|
|
I have a table with following columns: division * group * email Then, i create a non-unique index for: division * group I insert the following data: division * group * email 1 * * * * * *A * * * * a... (AT) hotmail (DOT) com 1 * * * * * *A * * * * b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division * group 1 * * * * * *A or will it contains 2 index records, i.e. division * group 1 * * * * * *A 1 * * * * * *A Thanks for prompt reply. |
answer directly.
But I do have to ask: Why do you care? What business need will this
knowledge serve?
Ed
#5
| |||
| |||
|
|
On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed |
#6
| |||
| |||
|
|
On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed |
#7
| |||
| |||
|
|
On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed |
#8
| |||
| |||
|
|
On Feb 19, 9:22 pm, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote: On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed the DBMS is Informix. Just want to know the structure only. |
http://publib.boulder.ibm.com/infoce...v111/index.jsp
http://www-306.ibm.com/software/data/informix/pubs/
robert
#9
| |||
| |||
|
|
On Feb 19, 9:22 pm, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote: On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed the DBMS is Informix. Just want to know the structure only. |
http://publib.boulder.ibm.com/infoce...v111/index.jsp
http://www-306.ibm.com/software/data/informix/pubs/
robert
#10
| |||
| |||
|
|
On Feb 19, 9:22 pm, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote: On Feb 19, 4:32 am, falcons... (AT) gmail (DOT) com wrote: I have a table with following columns: division group email Then, i create a non-unique index for: division group I insert the following data: division group email 1 A a... (AT) hotmail (DOT) com 1 A b... (AT) hotmail (DOT) com With this set of data in table, will the index table consist of 1 index record, i.e. division group 1 A or will it contains 2 index records, i.e. division group 1 A 1 A Thanks for prompt reply. You give No mention of what DBMS you are using so it is impossible to answer directly. But I do have to ask: Why do you care? What business need will this knowledge serve? Ed the DBMS is Informix. Just want to know the structure only. |
http://publib.boulder.ibm.com/infoce...v111/index.jsp
http://www-306.ibm.com/software/data/informix/pubs/
robert
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.