Search results for query: *

you can write a recursive function where u can pass the current id, the function will find the child and will call itself again with the child id. but what have to take care is, don't call the self function from inside the cursor, becs cursors will be always global and it will be closed first...

i m creating a huge database abour 4TB size. many tables with many indexes are there. how can i know the index key size using a single query? because i can know the size by adding all the columns size i took to create index, but is there any system table provided using what i can get the key...