This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
sql:explain:home [2010/05/13 21:40] tdo |
sql:explain:home [2012/10/26 14:51] (current) |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| Any time see Retrieve, Omnidex had to read the data files. | Any time see Retrieve, Omnidex had to read the data files. | ||
| - | |||
| ==== Optimization ==== | ==== Optimization ==== | ||
| Line 51: | Line 50: | ||
| select count(*) from INDIVIDUAL | select count(*) from INDIVIDUAL | ||
| + | |||
| + | What enables navigation from child to parent is just putting prejoin on a constraint. | ||
| + | |||
| + | Typically don't have to create custom indexes for this type of prejoin index operation. | ||
| + | |||
| + | custom indexes with prejoins can have further options such as record_complex and record_specific. | ||
| + | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||